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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column of many part numbers and I need to add a suffix to them for
picture files.
 
=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
 
I got this from Excel help file

Select the cells you want to format.
On the Format menu, click Cells, and then click the Number tab.
In the Category list, click Custom.
In the Type box, edit the number format codes to create the format you
want.
To display both text and numbers in a cell, enclose the text characters
in double quotation marks (" ") or precede the numbers with a backslash
(\). Editing a built-in format does not remove the format.

Adding 0".jpg" in the Custom, Type box changes the number in cell from
1234 to 1234.jpg
 
You must log in or register to reply here.

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

if a cell has data, add suffix "N" 4
Sorting rows with alphanumeric starter cells 8
return a value in one cell based on multiple formulas 2
Creating drop downs for part number configuration 2
Change 2 digit suffix in 14 digit number in a column of numbers. 1
Sorting Numbers with letter suffixes 8
MID, LEFT, RIGHT help 5
Help With Searching For Strings In Part Numbers 3

Back
Top