ExcelBanter - Add same text to the end of each cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Add same text to the end of each cell (https://www.excelbanter.com/excel-discussion-misc-queries/266091-add-same-text-end-each-cell.html)

JonathanDragonDJ

Add same text to the end of each cell

I have a column of numbers and i just want to add .jpg to each cell in the column.

How can I make excel do this in one go?

so that i turn

777
888
2343

into
777.jpg
888.jpg
2343.jpg

thanks!

wickedchew

Quote:

Originally Posted by JonathanDragonDJ (Post 959748)

I have a column of numbers and i just want to add .jpg to each cell in the column.

How can I make excel do this in one go?

so that i turn

777
888
2343

into
777.jpg
888.jpg
2343.jpg

thanks!

Supposing that:

A1 = 777

the formula should be: =CONCATENATE(A1,".jpg")

All times are GMT +1. The time now is 05:11 PM.