Aussie racing

[KAYEFF]

When I log an Australian race to Excel, the horse name comes with it's saddle cloth number... 1. Mr Ed. When I do UK races it just shows Mr Ed. This causes a problem when trying to do an excel match... 1. Mr Ed isn't the same as Mr Ed. How do I get rid of, or not load, the leading saddle cloth number with the horse name when logging Australian races to Excel?

[GaryRussell]

You could remove the prefix before doing the comparison with the following formula.

Code: Select all

=TRIM(MID(A5, FIND(".", A5) + 1, LEN(A5)))

[KAYEFF]

Thanks Gary, that worked a treat.