| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Splitting information in cells
I need to split information in one cells into various cells. EG B1 holds an
address, 11 One Street, Kookoo, 1111. I want to divided that info into A1- 11 One Street, A2 - Kookoo, A3 - 1111. I would appreciate it if someone can help please. -- Zippy |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Splitting information in cells
I provided a similar answer a few minutes ago to another person. Here is your
quick answer. This should not be too hard. Assuming that all your data is in one column. 1: Select /highlight the range/column with the numbers and names. 2: Go to the Data menu, select TEXT TO COLUMNS. 3: Select the DELIMITED option, press NEXT 4: Select the OTHER option, enter a comma in the space provided. 5: Press NEXT. 5: Press FINISH -- tech1NJ "Zippy" wrote: I need to split information in one cells into various cells. EG B1 holds an address, 11 One Street, Kookoo, 1111. I want to divided that info into A1- 11 One Street, A2 - Kookoo, A3 - 1111. I would appreciate it if someone can help please. -- Zippy |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Splitting information in cells
Hi Tech1nj, Am I missing something? I have tried and end up with all of the
data in one cell. I need to split the data. Sorry I am a bit new at this and could not work it out. -- Zippy "tech1NJ" wrote: I provided a similar answer a few minutes ago to another person. Here is your quick answer. This should not be too hard. Assuming that all your data is in one column. 1: Select /highlight the range/column with the numbers and names. 2: Go to the Data menu, select TEXT TO COLUMNS. 3: Select the DELIMITED option, press NEXT 4: Select the OTHER option, enter a comma in the space provided. 5: Press NEXT. 5: Press FINISH -- tech1NJ "Zippy" wrote: I need to split information in one cells into various cells. EG B1 holds an address, 11 One Street, Kookoo, 1111. I want to divided that info into A1- 11 One Street, A2 - Kookoo, A3 - 1111. I would appreciate it if someone can help please. -- Zippy |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Splitting information in cells
I think that I can better help you if you post a sample of your data.
Meanwhile, the step by step instructions below will work. -- tech1NJ "tech1NJ" wrote: I provided a similar answer a few minutes ago to another person. Here is your quick answer. This should not be too hard. Assuming that all your data is in one column. 1: Select /highlight the range/column with the numbers and names. 2: Go to the Data menu, select TEXT TO COLUMNS. 3: Select the DELIMITED option, press NEXT 4: Select the OTHER option, enter a comma in the space provided. 5: Press NEXT. 5: Press FINISH -- tech1NJ "Zippy" wrote: I need to split information in one cells into various cells. EG B1 holds an address, 11 One Street, Kookoo, 1111. I want to divided that info into A1- 11 One Street, A2 - Kookoo, A3 - 1111. I would appreciate it if someone can help please. -- Zippy |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Splitting information in cells
Hi again, Thankyou for your help. I have laid out the problem below.
The info in cell A1 needs to be split into cells B1,C1,D1,E1 A1 - 11 Smith Street, Smithville, Vic, 3500 B1 - 11 Smith Street, C1 - Smithville, D1 - Vic, E1 - 3500 I hope this is OK, Cheers -- Zippy "tech1NJ" wrote: I think that I can better help you if you post a sample of your data. Meanwhile, the step by step instructions below will work. -- tech1NJ "tech1NJ" wrote: I provided a similar answer a few minutes ago to another person. Here is your quick answer. This should not be too hard. Assuming that all your data is in one column. 1: Select /highlight the range/column with the numbers and names. 2: Go to the Data menu, select TEXT TO COLUMNS. 3: Select the DELIMITED option, press NEXT 4: Select the OTHER option, enter a comma in the space provided. 5: Press NEXT. 5: Press FINISH -- tech1NJ "Zippy" wrote: I need to split information in one cells into various cells. EG B1 holds an address, 11 One Street, Kookoo, 1111. I want to divided that info into A1- 11 One Street, A2 - Kookoo, A3 - 1111. I would appreciate it if someone can help please. -- Zippy |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Splitting information in cells
This helps a great deal. In looking at this example, I am confident that the
recommendation suggested earlier will work. All you have to do is make sure that you follow the steps as indicated. -- tech1NJ "Zippy" wrote: Hi again, Thankyou for your help. I have laid out the problem below. The info in cell A1 needs to be split into cells B1,C1,D1,E1 A1 - 11 Smith Street, Smithville, Vic, 3500 B1 - 11 Smith Street, C1 - Smithville, D1 - Vic, E1 - 3500 I hope this is OK, Cheers -- Zippy "tech1NJ" wrote: I think that I can better help you if you post a sample of your data. Meanwhile, the step by step instructions below will work. -- tech1NJ "tech1NJ" wrote: I provided a similar answer a few minutes ago to another person. Here is your quick answer. This should not be too hard. Assuming that all your data is in one column. 1: Select /highlight the range/column with the numbers and names. 2: Go to the Data menu, select TEXT TO COLUMNS. 3: Select the DELIMITED option, press NEXT 4: Select the OTHER option, enter a comma in the space provided. 5: Press NEXT. 5: Press FINISH -- tech1NJ "Zippy" wrote: I need to split information in one cells into various cells. EG B1 holds an address, 11 One Street, Kookoo, 1111. I want to divided that info into A1- 11 One Street, A2 - Kookoo, A3 - 1111. I would appreciate it if someone can help please. -- Zippy |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Splitting information in cells
Hello again, Thankyou very very much. This is exactly what I needed. Sorry
I was such a dodo to begin with. Cheers -- Zippy "tech1NJ" wrote: This helps a great deal. In looking at this example, I am confident that the recommendation suggested earlier will work. All you have to do is make sure that you follow the steps as indicated. -- tech1NJ "Zippy" wrote: Hi again, Thankyou for your help. I have laid out the problem below. The info in cell A1 needs to be split into cells B1,C1,D1,E1 A1 - 11 Smith Street, Smithville, Vic, 3500 B1 - 11 Smith Street, C1 - Smithville, D1 - Vic, E1 - 3500 I hope this is OK, Cheers -- Zippy "tech1NJ" wrote: I think that I can better help you if you post a sample of your data. Meanwhile, the step by step instructions below will work. -- tech1NJ "tech1NJ" wrote: I provided a similar answer a few minutes ago to another person. Here is your quick answer. This should not be too hard. Assuming that all your data is in one column. 1: Select /highlight the range/column with the numbers and names. 2: Go to the Data menu, select TEXT TO COLUMNS. 3: Select the DELIMITED option, press NEXT 4: Select the OTHER option, enter a comma in the space provided. 5: Press NEXT. 5: Press FINISH -- tech1NJ "Zippy" wrote: I need to split information in one cells into various cells. EG B1 holds an address, 11 One Street, Kookoo, 1111. I want to divided that info into A1- 11 One Street, A2 - Kookoo, A3 - 1111. I would appreciate it if someone can help please. -- Zippy |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Splitting information in cells
Not a problem. Please do not forget to rate the post to indicate if it was
helpful or not. Thanks -- tech1NJ "Zippy" wrote: Hello again, Thankyou very very much. This is exactly what I needed. Sorry I was such a dodo to begin with. Cheers -- Zippy "tech1NJ" wrote: This helps a great deal. In looking at this example, I am confident that the recommendation suggested earlier will work. All you have to do is make sure that you follow the steps as indicated. -- tech1NJ "Zippy" wrote: Hi again, Thankyou for your help. I have laid out the problem below. The info in cell A1 needs to be split into cells B1,C1,D1,E1 A1 - 11 Smith Street, Smithville, Vic, 3500 B1 - 11 Smith Street, C1 - Smithville, D1 - Vic, E1 - 3500 I hope this is OK, Cheers -- Zippy "tech1NJ" wrote: I think that I can better help you if you post a sample of your data. Meanwhile, the step by step instructions below will work. -- tech1NJ "tech1NJ" wrote: I provided a similar answer a few minutes ago to another person. Here is your quick answer. This should not be too hard. Assuming that all your data is in one column. 1: Select /highlight the range/column with the numbers and names. 2: Go to the Data menu, select TEXT TO COLUMNS. 3: Select the DELIMITED option, press NEXT 4: Select the OTHER option, enter a comma in the space provided. 5: Press NEXT. 5: Press FINISH -- tech1NJ "Zippy" wrote: I need to split information in one cells into various cells. EG B1 holds an address, 11 One Street, Kookoo, 1111. I want to divided that info into A1- 11 One Street, A2 - Kookoo, A3 - 1111. I would appreciate it if someone can help please. -- Zippy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| splitting up information in a cell | Excel Discussion (Misc queries) | |||
| Process for splitting information in a cell(s) | Excel Discussion (Misc queries) | |||
| Splitting Information in a Cell | Excel Discussion (Misc queries) | |||
| I'm stumped, splitting up a clump of text into useable information | Excel Discussion (Misc queries) | |||
| Splitting Cells | Excel Discussion (Misc queries) | |||
Linear Mode
