View Single Post
  #2   Report Post  
wickedchew wickedchew is offline
Senior Member
 
Location: Philippines
Posts: 161
Default

Quote:
Originally Posted by JonathanDragonDJ View Post
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")
__________________
Asobi Wa Owari Da