thanks pete but i still cant get it to work, i put the formula in the C
colum but it wont let me copy all the way down in C colum.

help

Marshall

"Pete_UK" wrote:

You can use a helper column to do this. Assuming your data is in column
A, in another blank column you can enter this formula in cell 1:

=A1&".jpg"

Then copy this formula all the way down to the bottom of your data.
Highlight all the cells with this formula in and click <copy, then
position the cursor on cell A1 and Edit | Paste Special | Values
(check) OK then <Esc. You can now delete your helper column.

Hope this helps.

Pete