jakepenner
New Member
- Joined
- Dec 11, 2019
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hello! Any help with this would be awesome. Excel illiterate here...
I have a sheet in which one of the columns consists of cells with many strings of numbers (5 digits), each separated by semicolons. I need to insert a dash (-) between the 2nd and 3rd digits of each of the five-digit number strings, so that...
"09000; 09050; 09100; 09110" becomes "09-000; 09-050; 09-100; 09-110"
And I need this change applied to the contents of every cell in the entire column. Any ideas? Thanks so much!
I have a sheet in which one of the columns consists of cells with many strings of numbers (5 digits), each separated by semicolons. I need to insert a dash (-) between the 2nd and 3rd digits of each of the five-digit number strings, so that...
"09000; 09050; 09100; 09110" becomes "09-000; 09-050; 09-100; 09-110"
And I need this change applied to the contents of every cell in the entire column. Any ideas? Thanks so much!