Copy a word from a cell with a sentence in it

[leeksleeks]

Hi,

I am having trouble trying to write some code that will extract a word(s) from a cell that has asentence in it as can be seen below:[TABLE="width: 50"]
<tbody>[TR]
[TD][TABLE="width: 655"]
<tbody>[TR]
[TD="width: 655"](Class 4) (4yo+) 2m3f Heavy 10 hdles[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
I have tried Text to Columns but when I change from Race to race the amount of information changes and everything parts of words are chopped off and split into other cells etc. What iw ant is to be able to extract Class (Class4), the distance (2m3f) and the going (Heavy). I then want to copy that information from a worksheet called 'Meeting to a worksheet called 'Results'.

Much the same as above when a cell has:

[TABLE="width: 50"]
<tbody>[TR]
[TD][TABLE="width: 655"]
<tbody>[TR]
[TD="width: 655"]<!-- -->Vinetta 16/1 [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
or
[TABLE="width: 50"]
<tbody>[TR]
[TD][TABLE="width: 655"]
<tbody>[TR]
[TD="width: 655"]<!-- -->Croco Bay (IRE) 16/1 [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

How do I copy just the 16/1 onto the worksheet called "Results".

Any help you can provide will be very helpful.

Cheers

 

[L. Howard]

These are tricky, at least for me. Not sure how it will work on your other entries but you can tweak a bit.
Change the sheet names to suit your worksheets.

 In cell B2 of sheet1    (Class 4) (4yo+) 2m3f Heavy 10 hdles

 In cell A3 of sheet2   =LEFT(Sheet1!B2,FIND(") (",Sheet1!B2))
 In cell B3 of sheet2   =MID(Sheet1!B2,FIND(") ",Sheet1!B2,10)+2,4)
 In cell C3 of sheet2   =MID(Sheet1!B2,FIND(Sheet2!D21,Sheet1!B2)+LEN(B3),6)


In cell B4 of sheet1   Vinetta 16/1

 In cell D3 of sheet2  =RIGHT(Sheet1!B4,4)  or  =RIGHT(Sheet1!B4,5)

Regards,
Howard