View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nick nick is offline
external usenet poster
 
Posts: 192
Default Adding Dashes to a 25 digit alphanumeric cell

I have a column of 30-5k consisting of a 25 digit alphanumeric code. I need
to reformat these to have dashes every 5 characters. example:
XXXXXXXXXXXXXXXXXXXXXXXXXX
to
XXXXX-XXXXX-XXXXX-XXXXX-XXXXX

Is there a custom format string that I can use to do this automatically? My
right arrow key is getting worn down here, :P

Thanks in advance,

Nick