Menu
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
669
Move your cursor right, then press Ctrl + Shift + ↑; this will select all cells up to the last cell with contents (the one you just wrote your formula in). Press Ctrl + V to paste your contents.
There is a simple function “CONCATENATE()” in LibreOffice. Click into the result cell (eg B2). Click on the “Function Wizard”=“fx”. Select the function “CONCATENATE()”.
To merge a group of cells into one cell: Select the cells to merge. Right-click and select Cell > Merge on the pop-up menu, or select Table > Merge Cells from the menu bar.
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.
152
This is just another option,
just click the function wizard and select concatenate, in that enter which column you want to enter as text1 as and second column in text2. Then when you click OK you will get an concatenated column like below image
so in the C column you will get as a1.jpg.
23
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
