Thread: Splitting cels contents into two cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Splitting cels contents into two cells
In O49:
=LEFT(M49,FIND(" ",M49)-1)
in P49:
=MID(M49,FIND(" v ",M49)+3,FIND(",",M49)-FIND(" v ",M49)-3)

--
Gary''s Student - gsnu200909
Reply With QuoteReply With Quote