Hi

As there are no delemitters in the string we have to insert some.

Select the cells, goto Edit Find Find what: " " (enter two spaces)
Replace Replace with ", " Replace All.

Now use TextToColumns with the comma as delemiter"

Hopes this helps

---
Per

"yaro137" skrev i meddelelsen
...
Well it didn't display right. I'll try without lines so it should be:

A
B C
The Long House 8 Cavendish Square Barnet
33 Kings Road High Road Putney
9 Sesame Street Kent

Hope this is clearer.
yaro