I have a column of many part numbers and I need to add a suffix to them for picture files.
G Gene's General Aug 10, 2006 #1 I have a column of many part numbers and I need to add a suffix to them for picture files.
G Gord Dibben Aug 10, 2006 #2 =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
=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
