I'm looking to split a large amount of data into separate columns so that it can be further manipulated.
I have around 2000 rows of data which have been extracted from elsewhere. There's currently only one column for all these rows but each cell contains a lot of information which is very rarely identical in length.
It's records of phone calls so they're generally laid out as follows;
Initials "for" initials "(" Equipment + Peripheral 1 + Peripheral 2 ")" "=" 4-6 digit number
Sometimes a single row may contain 2 or 3 sets of equipment & peripherals information.
I'm just looking to separate every separate word at the moment and then take it from there.
Can anyone suggest the quickest method to have everything separated out?
Bookmarks