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: [email protected]
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
