In B1 enter =A1 & ".jpg"

Double-click on the fill handle(bottom right corner black lump) of B1 to copy
down.

Whe happy with results, select column B and, in place, EditPaste
SpecialValuesOKEsc.

Delete column A


Gord Dibben MS Excel MVP


On Mon, 14 Jan 2008 15:14:00 -0800, The DLC <The
wrote:

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!