That depends on which pieces of information in the text string you're after, (or maybe all 3)
1. Call
2. Lengths behind
3. Racing wide
By using formulas in a new column(field), the Call would be
after substituting "" for "°"=Value(LEFT(ref,FIND("/",ref)-1))..........ref is to the cells like "5/°1H"
Lengths behind would be similar using the right hand portion of the string and substituting ".5" for "H" . . ".25" for "Q" and so on.
The bubbles ° can be found the same way, using the "Find" formula.
This can also be done in the VBA code.
BTW
I do this for pplines in the race program where TM uses those crazy chars for fractional lengths.
(Can't post the chars with this Forum's font)
=VALUE(IF(OR(AT2="nk",AT2="hd",AT2="ns"),0.01,
IF(RIGHT(AT2,1)="?",SUBSTITUTE(AT2,"?",".25"),
IF(RIGHT(AT2,1)="?",SUBSTITUTE(AT2,"?",".5"),
IF(RIGHT(AT2,1)="?",SUBSTITUTE(AT2,"?",".75"),
IF(AT2="ds",20,AT2))))))
