Quote:
Originally Posted by JonathanDragonDJ
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")