for Garys Student
 

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

for Garys 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.
--
Gary''s Student - gsnu200909


"stew" wrote:

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

for Garys Student
 

thank you again

I do learn so much everytime I have ask

Thanks
Stew

"Gary''s Student" wrote:

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.
--
Gary''s Student - gsnu200909


"stew" wrote:

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