View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rayofsunshine969 rayofsunshine969 is offline
external usenet poster
 
Posts: 1
Default If I have a list of numbers, how do I insert a dash in each one?

If I have a list of numbers, 11 characters long, example: 00229603210, and
for each number I want a dash behind every 2nd, 6th and 9th number,
00-2296-032-10. Is there an easy way to do this?