Adding a prefix to all numbers in a column.

R

Randy

I have a spreadsheet containing part numbers and I want to add a text prefix
before each number to identify it by manufacturer. i.e. Part Number 12345 -
I need to add a manufacturer identifier MANUFACTURERA-12345 to all part
numbers in a spreadsheet.

Can anyone help me to develop a macro to accomplish this or tell me how to
combine a text field column with a numeric column?

I would sincerely appreciate the help! Thank you.
 
P

pinmaster

Let's assume you have the manufacturer's name in column A and part number in
column B, in a blank column you would type:

=A1&"-"&B1

or let's say you only want to use the first 2 letters of the manufacturer's
name

=LEFT(A1,2)&"-"&B1

when you're done you copy then Paste Special / Values.

HTH
JG
 
Y

YesPee

Hi,Randy

In Cell A1 contains 12345
Just type in cell B1
="MANUFACTURERA"&"-"&A1


sp_prabhakaran(at)yahoo.co
 
Top