Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Shortcut to split data from one column into three? HELP!
I have a large sheet of data that needs immediate work done to it so it can
be better used/searched by my boss. He now wants a column currently containing city/state/zip into three separate columns. I'm sure there is some way to split these into three columns without having to manually do it (I just don't have the time - it's a long enough list it would take three days). But I do not know these functions (macro?) well enough. Is this possible? Can ANYONE help me with this? I have Excel XP and there doesn't seem to be Microsoft Support for this product. Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Shortcut to split data from one column into three? HELP!
One way. Select your column or rangedatatext to columnsdelimitedtab &
space or a macro but you don't give examples. -- Don Guillett Microsoft MVP Excel SalesAid Software "LenoraMarie" wrote in message ... I have a large sheet of data that needs immediate work done to it so it can be better used/searched by my boss. He now wants a column currently containing city/state/zip into three separate columns. I'm sure there is some way to split these into three columns without having to manually do it (I just don't have the time - it's a long enough list it would take three days). But I do not know these functions (macro?) well enough. Is this possible? Can ANYONE help me with this? I have Excel XP and there doesn't seem to be Microsoft Support for this product. Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Shortcut to split data from one column into three? HELP!
Go to DataText to Columns
Select the Delimited radio button Click the relevant checkbox(s). Whatever seperates the city/state/zip. If a comma or '/' seperates the information select the other option and then enter whatever applies. If there is any data in columns after the city/state/zip column you will want to insert some empty rows to avoid erasing any data in the neighboring columns. "LenoraMarie" wrote: I have a large sheet of data that needs immediate work done to it so it can be better used/searched by my boss. He now wants a column currently containing city/state/zip into three separate columns. I'm sure there is some way to split these into three columns without having to manually do it (I just don't have the time - it's a long enough list it would take three days). But I do not know these functions (macro?) well enough. Is this possible? Can ANYONE help me with this? I have Excel XP and there doesn't seem to be Microsoft Support for this product. Thanks! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Shortcut to split data from one column into three? HELP!
THANK YOU - problem solved and a new trick learned. MUCH MUCH APPRECIATED!
"Stephen Lloyd" wrote: Go to DataText to Columns Select the Delimited radio button Click the relevant checkbox(s). Whatever seperates the city/state/zip. If a comma or '/' seperates the information select the other option and then enter whatever applies. If there is any data in columns after the city/state/zip column you will want to insert some empty rows to avoid erasing any data in the neighboring columns. "LenoraMarie" wrote: I have a large sheet of data that needs immediate work done to it so it can be better used/searched by my boss. He now wants a column currently containing city/state/zip into three separate columns. I'm sure there is some way to split these into three columns without having to manually do it (I just don't have the time - it's a long enough list it would take three days). But I do not know these functions (macro?) well enough. Is this possible? Can ANYONE help me with this? I have Excel XP and there doesn't seem to be Microsoft Support for this product. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Split Data in One Column Into Two | Excel Discussion (Misc queries) | |||
Shortcut to change view so that column widths are all wide enough to show all data? | Excel Discussion (Misc queries) | |||
Shortcut to select column with data in previous column | Excel Discussion (Misc queries) | |||
Split data in column | Excel Worksheet Functions | |||
How do I split data in a column (formula)? | Excel Discussion (Misc queries) |