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?