View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SteW SteW is offline
external usenet poster
 
Posts: 293
Default Splitting cels contents into two cells

Hi all

I have this in Cell m49
Birmingham v West Ham, 15:00
The contents are always displayed with the v in the middle after the hast
name a comma
In this case I would like the Birmingham to appear in cell o49 and west ham
to appear in p49 and ignore the 15:00

the two names change in size bur the v and comma always appear as shown above

Thanks for looking

Stew