Add leading #'s to a value

M

MikeD1224

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
 
Top