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

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

Splitting cels contents into two cells
 

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

Splitting cels contents into two cells
 

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

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

Splitting cels contents into two cells
 

Without formulas.

DataText to ColumnsDelimited by v and comma

Next......select the column with the time and "skip"

Destination...........O49

Finish.


Gord Dibben MS Excel MVP

On Sun, 6 Dec 2009 05:08:01 -0800, stew
wrote:

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