I'm trying to extract several bits of data from one cell, and paste it into other individual cells.
The data is currently a long string, that contains 8 fields. Each field has a title and then a colon, and then the relevant data.
It looks like this with 8 fields and 8 bits of data.
Field 1:Data1Field 2:Data2
I've tried using convert to columns which didn't seem to recognise the colon.
Anyone advise the best way to separate so that the data from Field 1 goes in one cell, then data from Field 2 goes in another cell and so on.
Thanks in advance ?