Splitting information in cells

[Zippy]

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.

 

[tech1NJ]

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

 

[Zippy]

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.

 

[tech1NJ]

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.

 

[Zippy]

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

 

[tech1NJ]

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.

 

[Zippy]

Hello again, Thankyou very very much. This is exactly what I needed. Sorry
I was such a dodo to begin with. Cheers

 

[tech1NJ]

Not a problem. Please do not forget to rate the post to indicate if it was
helpful or not. Thanks