Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Splitting contents of column into 4
I have a very large data base, the column containing addresses needs to have
the information split into 4 columns. Currently the address, Unit number,Town/State, and Zip is in one column. I need to split the contents of each of these 4 things into 4 separate columns. How do I do it?? Thanks so much in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Splitting contents of column into 4
Hi,
Try with Data/Text to Columns. Wkr, JP "Daphtg" wrote in message ... I have a very large data base, the column containing addresses needs to have the information split into 4 columns. Currently the address, Unit number,Town/State, and Zip is in one column. I need to split the contents of each of these 4 things into 4 separate columns. How do I do it?? Thanks so much in advance |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Splitting contents of column into 4
If you have a delimiter in between each field use Data'Text to Columns
'options --Select the range/column needs to be changed. From menu DataText to Columns will populate the 'Convert Text to Columns Wizard' --By default the selection is 'Delimited'. --Keep the selection and hit 'Next'. --From the Step2 of the Wizard from the options Tab,Semicolon,Comma,Space,Other select your separator.. Specify in other and hit Next. --Hit Finish If this post helps click Yes --------------- Jacob Skaria "Daphtg" wrote: I have a very large data base, the column containing addresses needs to have the information split into 4 columns. Currently the address, Unit number,Town/State, and Zip is in one column. I need to split the contents of each of these 4 things into 4 separate columns. How do I do it?? Thanks so much in advance |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Splitting contents of column into 4
Try using the text to columns feature.
"Daphtg" wrote: I have a very large data base, the column containing addresses needs to have the information split into 4 columns. Currently the address, Unit number,Town/State, and Zip is in one column. I need to split the contents of each of these 4 things into 4 separate columns. How do I do it?? Thanks so much in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Splitting contents of a cell from one column into 2 | Excel Worksheet Functions | |||
Splitting the contents. | Excel Discussion (Misc queries) | |||
splitting out cell contents | Excel Discussion (Misc queries) | |||
Splitting cell contents | Excel Discussion (Misc queries) | |||
Splitting cell contents | Excel Discussion (Misc queries) |