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
|