| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
insert a dash
I have a column of numbers, 5 digit up to 9 digit. I need to insert a dash
after the first number of any 5 digit number, and a dash after the second digit if the number is longer than 5 digits. so 12345 would need to become 1-2345 and 1234567 would need to become 12-34567 If my original numbers are in column A, I can make the new ones in Column B |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If I have a list of numbers, how do I insert a dash in each one? | Excel Discussion (Misc queries) | |||
| How insert a dash in the third position of a column with data? | Excel Discussion (Misc queries) | |||
| insert a dash | Excel Programming | |||
| Need insert a dash in between last 4 digits in text string | Excel Worksheet Functions | |||
| Shortcut Key to insert an em-dash? | Excel Programming | |||
Threaded Mode
