Count from the right in a string.

[Bob1955]

Hi,

I have a string of numbers representing a horse's last 10 races as below.

s04781s249

I am trying to count the runs since the last spell represented by "s". The formula I have =IFERROR(LEN(T2)-FIND("s",T2,1),"") only works if there is one "s". In ths case above in will give the result 9.

I would like a fomula that counts from the right to give the result as above "3".

Any help would be appreciated.

Bob

[Bob1955]

Sample of the worksheet attached.

[Bo_Ry]

Please try

=LEN(-LOOKUP(0,-RIGHT(T2,SEQUENCE(LEN(T2)))))

[Glenn Kennedy]

Maybe this:

=LEN(TRIM(TRIM(RIGHT(SUBSTITUTE(A1,"s",REPT(" ",100)),100))))

[Bob1955]

That does the trick Glen. You are a champion. Thank you.

[BMV]

You are a champion.

but why

Please Login or Register  to view this content.

[Glenn Kennedy]

Absolutely no idea why.... seeing double??

=LEN(TRIM(RIGHT(SUBSTITUTE(D7,"s",REPT(" ",100)),100)))

...unless it's because I'm Irish... to be sure to be sure....