This page is outdated. You will be redirected to http://wiki.services.openoffice.org /wiki/Documentation/FAQ shortly.

Documentation / User FAQ / Calc / Previous-Next

How do I add trailing characters to a cell?

If what you have are index numbers like "DCP_5509" in column B and you want to add a common suffix like "myparty.jpg" to the end of this existing data, then enter the function =CONCATENATE(B1;"myparty.jpg") into a new cell that will show the index number from cell B1 with the new suffix attached. Next, apply this function to the rest of the cells in the new column. Copy the first cell in the new column, then paste it to the remaining cells in that column. Now the new column displays "DCP_5509myparty.jpg" and the like.

Note: Alter the function to =CONCATENATE("myparty.jpg";B1) to add the additional characters as a prefix to the existing data from cell B1.

Documentation / User FAQ / Calc / Previous-Next