How to manipulate this string of text to make it readable?
- by Kenny
I have this string in an excel file:
4603,2504603#;4616,2504616#;4617,2504617#;4519,2504519#;4620,2504620
(It's actually a lot longer than that, but the pattern is the same).
I need to be able to some how sort this into something that can be read easier. I want the end result to look like this:
4603,2504603
4616,2504616
4617,2504617
…