| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding to the row digit in the cell reference | Excel Discussion (Misc queries) | |||
| Generate alphanumeric unique 4 digit values from 12 digit values | Excel Worksheet Functions | |||
| Adding a 0 to a four digit number | Excel Discussion (Misc queries) | |||
| Color a single digit in a mult-digit number cell | Excel Discussion (Misc queries) | |||
| Adding a digit | Excel Discussion (Misc queries) | |||
Threaded Mode
