=A1 & ".jpg" entered in B1

Or whatever file extension you want.

Double-click on the fill handle of B1 to copy down.

When happy with results, copy column B and Paste Special(in
place)>Values>OK>Esc.

Delete original column.


Gord Dibben MS Excel MVP


On Thu, 10 Aug 2006 10:11:02 -0700, Gene's General <Gene's
General@discussions.microsoft.com> wrote:

>I have a column of many part numbers and I need to add a suffix to them for
>picture files.