How do I add additional strings or characters to cell contents?
From Apache OpenOffice Wiki
< Documentation | FAQ | Calc | Formatting
How do I add additional strings or characters to cell contents?
Use the CONCATENATE function to add strings or characters to cell contents:
- Go to an empty cell
- Enter =CONCATENATE("prefix";A1;"suffix") as the cell contents
"prefix" being any text you would like to add in front of the existing cell contents
A1 being the original cell
"suffix" being any text you would like to add after the existing cell contents
Example:
- Original Cell "C5" with content "filename"
- In a new cell, enter =CONCATENATE("my_";C5;".ods")
- The new cell value will be "my_filename.ods"
