Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to split colums
I need to split information that I copied and pasted from word to excel..
example: (3/1/05 Westover, Ma) is in the same colum but I want to separate the date from the rest of the info... Does this make sense? Anyone out there that can help me? Thanks in advance |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to split colums
you can not split a column but you can use text to colums under the data menu
to do what you want -- John MOS Master Instructor Ofice 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "emgenx" wrote: I need to split information that I copied and pasted from word to excel.. example: (3/1/05 Westover, Ma) is in the same colum but I want to separate the date from the rest of the info... Does this make sense? Anyone out there that can help me? Thanks in advance |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to split colums
John Thanks! I searched the thread and found the same question answered..
You are correct the data menu will help... It's just that I have a larg amount of data that is not already separated with the ":"... So I entered it and then went to the data menu and did it that way... It worked but what if I have several hundred rows... would I have to insert the ":" everytime? Maybe I'm missing somethin! "john" wrote: you can not split a column but you can use text to colums under the data menu to do what you want -- John MOS Master Instructor Ofice 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "emgenx" wrote: I need to split information that I copied and pasted from word to excel.. example: (3/1/05 Westover, Ma) is in the same colum but I want to separate the date from the rest of the info... Does this make sense? Anyone out there that can help me? Thanks in advance |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to split colums
How about this method?
If all you want is the date pulled out, copy the column and DataText to ColumnsDelimited by "space"Next You will see your data in three columns in the Wizard.. Select column 2 and "Skip" Select column 3 and "Skip" Finish. Your dates are in a column by themselves. You can do the same to break out the other data also. Just takes a few steps through the Wizard. Gord Dibben MS Excel MVP On Thu, 15 Feb 2007 14:00:28 -0800, emgenx wrote: John Thanks! I searched the thread and found the same question answered.. You are correct the data menu will help... It's just that I have a larg amount of data that is not already separated with the ":"... So I entered it and then went to the data menu and did it that way... It worked but what if I have several hundred rows... would I have to insert the ":" everytime? Maybe I'm missing somethin! "john" wrote: you can not split a column but you can use text to colums under the data menu to do what you want -- John MOS Master Instructor Ofice 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "emgenx" wrote: I need to split information that I copied and pasted from word to excel.. example: (3/1/05 Westover, Ma) is in the same colum but I want to separate the date from the rest of the info... Does this make sense? Anyone out there that can help me? Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How i multiply colums D*E=g | Excel Discussion (Misc queries) | |||
Split the date & time in one cell to be 2 colums. | Excel Worksheet Functions | |||
Colums | Charts and Charting in Excel | |||
colums in xcel | Excel Discussion (Misc queries) | |||
Sum YTD Colums | Excel Discussion (Misc queries) |