I have this string in an excel file:
(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:
I guess I need a program or command that can replace #; with a line break. I need something that will work in Windows 7. I remember doing something similar to this in a Linux class using shell scripting but I can't remember how it was done.
Note: This is NOT homework. It is something my boss has asked me to do at work.