View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Faio
 
Posts: n/a
Default Separate 5digits by inserting -

I have a column containing codes and I wish to separate the first digit from
the rest by inserting a hyphen.
E.g 40000 to be 4-0000, 40001 to 4-0001.

Any suggestions rather than going thru a list of more than 1000s?