Thread: Convert stored numbers into a set naming convention
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Sean is offline
external usenet poster
  
Posts: 208
Default Convert stored numbers into a set naming convention
I have a list of around 2000 numbers ranging from 3 to six digits. I need to
convert all numbers to six digits with leading zeros is 345 becomes 000345
and 12345 becomes 012345.

I also need to convert all of those to a set naming convention with a set
prifix letter M and followed by PC001
so 345 becomes M000345PCOO1
AND 12345 BECOMES M012345PC001.

All original numbers are stored as numbers on one column
Can anyone help?
Reply With QuoteReply With Quote