RE:[libreoffice-users] Adding text from a specific cell to the end of a text string

Greetings,

You can use one of two methods:

1) The CONCATENATE function way: Replace the text you have typed in with '=CONCATENATE("The RMD 
Amount for tax year ",U14)' (no single quotes). This will have the cell show the information you 
want.
2) The cell format way: In the cell where you have typed "The RMD (...)", remove what you have 
typed and replace the text with this formula: "=U14" (no quotes). For that same cell, create a 
format (Format > Cells...> Numbers, or CTRL-1) that looks like this: "The RMD Amount for tax year 
"# (the quotes are important).

I prefer number 2 because what you have in the cell that refers to U14 is still a number (not a 
string) and you can use it in other locations of your spreadsheet.

I hope this helps.
Rémy.

Hi:

I have typed: "/*The RMD Amount for tax year*/" (w/o quotes) into a cell .

I want to add to that text string the desired tax year in the space after "/*year*/" (which appears 
elsewhere in the calc sheet); i.e., from a specific cell within a previous row. For example, it 
should read as:  The RMD Amount for tax year _2025_, where _2025 _is already written into _cell 
U14_ of the same Calc sheet.How can this be accomplished?  CONCATENATE function?

Regards,

VinceB.

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy