|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 13th, 2008, 02:53 AM
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
August 13th, 2008, 03:02 AM
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
August 13th, 2008, 03:27 AM
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
August 13th, 2008, 01:52 PM
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
August 13th, 2008, 11:18 PM
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
August 14th, 2008, 09:57 PM
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
August 14th, 2008, 11:10 PM
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
August 15th, 2008, 01:38 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
