Libreoffice/Openoffice Calc - append string to cells

Gabriele picture Gabriele · May 20, 2013 · Viewed 29.7k times · Source

I need to add .jpg at the end of all he cells in one or more columns

9788895249971  into > 9788895249971.jpg
9788867230129  into > 9788867230129.jpg
9788867230273  into > 9788867230273.jpg
9788867230280  into > 9788867230280.jpg

Detailed step-by-step instructions are much appreciated since I am very new to Calc. Thanks

Answer

Robert Ilbrink picture Robert Ilbrink · May 20, 2013

Do you need to do this once or is this going to be a repeated task every week/month?

If it is something you need to do just once, here is what you can do:

Next (right) to the column where your numbers are open (insert) a new column. Assuming the following: Numbers are in column A, New column is column B.

In this new column B in the top cell (B1) write:

=A1&".jpg"

Now copy B1 all the way down to the end. In B1 type [Ctrl]+c then Hold [Shift] and hit [PgDn] until the end then press [Ctrl]+v. Highlight Column B, [Ctrl]+c, then [Edit] [Paste Special] values only (No formula's) this freezes the calculated data.