Stall and Race Numbers

[Duaneyk]

Hi all
First time posting. Haven't found an answer to this yet when going through the previous posts.

I do some betting on the US Horse Racing and also UK Greyhounds. I have used some of the sample spreadsheets to get started and populate my selections. They weren't firing which I then found to be because I have the runners name in the selection but, on the market tab, Betfair sends the stall number as part of the name ie 1. Horsey instead of just Horsey

I can get around it with Greyhounds due to the data I use (join the stall and runner name together), but I don't have stall numbers in my data for USA horses. Does anyone have a solution to this? I'm assuming a formula as part of the VLOOKUP but my attempts have so far been futile.

Any help appreciated.

[Captain Sensible]

You could use a helper column to strip out the number and match your vlookup to that column . I.e you strip the number out of the A column and put it in AA

With a formula you'd simply put in AA5

=IF(ISNUMBER(VALUE(LEFT(A5,1))), RIGHT(A5,LEN(A5)-FIND(" ",A5)), A5)

[Captain Sensible]

You can incorporate that as part of your Vlookup formula id you don't want to use another cell or even write it in VBA depending how competent your excel coding skills are.

One thing I'd suggest is using Chatgpt as that's very good and quick at doing any coding for you.

[Duaneyk]

Perfect, thanks very much for the formula. It works a treat.
I will look at VBA code at some point, but this lets me get it up and running.