Extracting data into cells from string

I have a problem that I hope someone can help me with. I have a list of horses, ratings and the going (ground conditions) that rating was achieved on. The problem is that all this data is in one cell as it's from a 3rd party app that I have no access to.

The cells consists of the following data for example -:

HOBSON 104(gf) JILLY WHY 103(hy) SION HILL 101(gf)

So you have the horse name - HOBSON, the rating 104 and the going in brackets (gf).

I want to extract each piece of data into 3 columns. So you have for example...

A2 - HOBSON
B2 - 104
C2 - gf
A3 - JILLY WHY
B3 - 103
C3 - hy
A4 - SION HILL
B4 - 101
C4 - gf

The problem is that I can't use text to columns using space as a delimiter because the horse names can have spaces.

Someone provided me with the following formula which works but it is really slow as I have 100+ rows like this...can anyone help, I'm desperate and have no clue with vb or scripting but am 'competent' in excel. Thanks in advance.

Please Login or Register  to view this content.