Add leading #'s to a value

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

Guest

I have a list of UPC's in Column A. Each UPC needs to have a series of
numbers added in front of the current UPC. How can I do this for the entire
column at once?

Ex.

Col A

0-35000-1

Would like it to read as such: 12340-35000-1

Thanks for any help.

Mike
 
Back
Top