How to paste to multiple cells as a suffix?

[GAMESHOW863]

I am trying to paste to multiple cells as a suffix for example

I have cells A1 to A5 with names of images

.....A

1 image_name_1
2 image_name_2
3 image_name_3
4 image_name_4
5 image_name_5

How would I quikly add ".jpg" to the end of each word in multiple cells at once?

[Paul]

Quickest way is to add a temporary helper column, for example:

Assuming your data starts in A1, in column B (or any empty column), put the formula in B1:

=A1&".jpg"

Fill that down as many rows as there are values in A. Then select that entire column (B, in this example) and choose Edit->Copy. Then select column A and choose Edit->PasteSpecial->Values. This will overwrite column A with your concatenated data in column B. You can then delete column B.

[GAMESHOW863]

It worked perfectly, Thanks for your help!

[Paul]

You're welcome, glad to be of assistance.