View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Randy
 
Posts: n/a
Default 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