How to add a suffix to a whole column of different part numbers?

G

Gene's General

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

Gord Dibben

=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parsing full name into salutation, First, middle, last, Suffix 1
if a cell has data, add suffix "N" 4
Embed the same Excel multiple times 0
How do I sort alpha neumeric fields that have an alpha suffix? 3
Finding the proper style field and the numbered paragraph value within the style 0
Autonumber field in Excel that behaves the same as Access 0
COUNTIF - help please 10
Two columns followed by single page-width column on same page 0

Top