View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SteW SteW is offline
external usenet poster
 
Posts: 293
Default 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