I am currently using Microsoft Excel 2011 for Mac. I am trying to separate data in the following format with delimiters. So far I have not been able to come up with a practical solution. Can anyone provide me with one?
The text is in the format below.
I would like the text to look like this.
I apologise if a similar answer has been provided previously, but I have not been able to find a working solution.