Macro to split large range of text with multiple delimiters.

So what i'm actually trying to do is completely clean and reshuffle some data into a set format. It's complicated. I don't know how to do it all in one go so I have just been doing it in parts. Hence why i asked to split which allows me to move differnet parts around.