View Single Post
  #5   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

You are very welcome!
--
Gary''s Student - gsnu200909


"stew" wrote:

thank you, and Thank Gary!!
Best

Stew

"Gary''s Student" wrote:

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