Hello all ,
I am hoping to get some functions that can give me the results I have already resulted for the first horse named
American Red .
I have some trim functions but unable to adapt them to this sheet .
Results will come from data in cols O and P .
There are many reference points I think that can help . The data is always quite clean and doesn?t change much .
Date2 is always just inside left beside mostly four letters , but sometimes only 2 or 3 letters .
Tab# is always left of horse name .
Horse name is always beside-right of tab# .
Plc comes from col O , and is to the left of the word of .
Dist. is always left of letter m .
Cond is always to right of letter m after a gap .
Marg is always to left of capital letter L .
Time is mostly mentioned in brackets but not always , seem to be right of letter m also . It would be great to get the time in
custom format of 00:34.99 as an example as then these can be filtered in ascending order . But if a standard
34.99 works for filtering that would be great .
The 800 and 400 numbers always appear left of this @ .
Hope I have explained it well .
Thanks .
Bookmarks