Adding a prefix to all numbers in a column.

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.
--
Randy

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



"Randy" wrote:

> 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.
> --
> Randy

Hi,Randy

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


sp_prabhakaran(at)yahoo.com


--
YesPee
------------------------------------------------------------------------
YesPee's Profile: http://www.hightechtalks.com/m898
View this thread: http://www.hightechtalks.com/t2352904