for Garys Student

[stew]

Hi again

Small problem, which may be a big Problem
in o49
=LEFT(M49,FIND(" ",M49)-1)
when applied to
St Mirren v Falkirk,Returns
ST
The p49
=MID(M44,FIND(" v ",M44)+3,FIND(",",M44)-FIND(" v ",M44)-3)
correctly returns St Johnstone
out of
Rangers v St Johnstone, 15:00
Can we solve the o49 Formula glitch?

Best

Stewart

 

[Gary''s Student]

A very easy fix. The original formula looked for " " and returned everything
to the left of it.

=LEFT(M49,FIND(" v ",M49)-1)

looks for " v " and returns everything to the left of it. This allows the
"front" part to contain embedded blanks.

 

[stew]

thank you again

I do learn so much everytime I have ask

Thanks
Stew