![]() |
#1
|
||||
|
||||
![]()
Hi. I have a column with numbers typed as
3000100123 I need to add zero before the first character, insert a hyphen after the first char, and insert another hyphen after the fifth, like 03-0001-00123 What I did to get the desired result was to create 5 helper columns parsing the numbers then joining them all. At first I tried creating a formula but gave up. How should I do it with a formula? Thank you. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
pjs15 | Word VBA | 2 | 02-04-2020 10:45 PM |
![]() |
sbktex | Word VBA | 2 | 09-17-2014 04:09 PM |
![]() |
omahadivision | Excel Programming | 12 | 11-23-2013 12:10 PM |
![]() |
cyndor | Word | 6 | 07-25-2012 06:40 AM |
outlook task notes creates hyphens | abt | Outlook | 0 | 05-09-2009 03:51 PM |