View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tyro[_2_] Tyro[_2_] is offline
external usenet poster
 
Posts: 1,091
Default add file extensions to a column

Put =A1&".jpg" in cell B1 and drag down in column B for every cell you want
to change in column A.

Tyro

"The DLC" <The wrote in message
...
Hello, I would like to add the file extension .jpg to the end of the
contents
of every cell in column A.

Right now I have cells with contents like

2004-11-034

and I would like to end up with

2004-11-034.jpg

I am new at all this, and can't for the life of me find a solution. Any
help
would be much appreciated. thank you!