for Garys Student

  • Thread starter Thread starter stew
  • Start date Start date
S

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
 
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.
 
Back
Top