Language:

The Free and Open Productivity Suite
Apache OpenOffice 4.1.6 released

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

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache and the Apache feather logo are trademarks of The Apache Software Foundation. OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.