| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Splitting the contents. | Excel Discussion (Misc queries) | |||
| Splitting cell contents | Excel Discussion (Misc queries) | |||
| Splitting cell contents | Excel Discussion (Misc queries) | |||
| Autofill cels based on two dates in adjacent cels | Excel Worksheet Functions | |||
| Splitting up a cells contents | Excel Worksheet Functions | |||
Linear Mode
