Adding a prefix to all numbers in a column.

[Guest]

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.

 

[Guest]

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