Seperating cells in excel 2

[dgwilliams]

i have imported all my contacts from outlook into excel. the thing is that the address for eac contact is imported into one cell with eachline seperated by a tab or comma. Is there someway i can split this address cell up into multiple cells each containing one line of the address.

Thanks for any help in advance.

 

[Wray69]

if they are seperated by a Tab or a Comma you could use Text to Columns. Just select your column then got to DATA/TEXT to COLUMNS choose delemeted and then use either your comma or Tab as the delimeter.

Regards,

Wray

 

[dgwilliams]

Yes but say if there are multiple lines to be seperated e.g

the house,the street,denmark,europe

and i want to seperate each line into a seperate cell

 

[PrgrmsAll]

The Test-to-Columns function will seperate the data into as many chunks as there are commas. If your problem is more complicated, you may need to write some relatively simple Visual Basic for Applications code behind the worksheet to do this.

 

[dgwilliams]

in my first question i was wrong they are seperated by returns any suggestions

 

[Wray69]

By returns???? Do you mean by spaces? If I export my contacts the address is seperated by spaces. Which you can do text to columns using a space as a delimeter, but where you are going to run into problems is that address have different amounts of words ie "mickey Way" would be seperated into 2 columns where as "mickey mouse way" would be 3 columns. This would mean you would have to go back and clean it up after you run text to columns.

Regards,

Wray