Thread
:
Separate 5digits by inserting -
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Faio
Posts: n/a
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?
Reply With Quote