How do I add additional strings or characters to cell contents?

From Apache OpenOffice Wiki
< Documentation‎ | FAQ‎ | Calc‎ | Formatting
Jump to: navigation, search


How do I add additional strings or characters to cell contents?


Use the CONCATENATE function to add strings or characters to cell contents:

  1. Go to an empty cell
  2. 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_";A1;".ods")
  • The new cell value will be "my_filename.ods"


Personal tools