You might try replacing your line breaks (assuming that they are in the form
of alt+enter) with a character such as "~" or "`".
=SUBSTITUTE(A1,CHAR(10),"~")

Once you've done that, copy that result and PasteSpecial, values only. Then
you can use Text to Columns using "~" as the delimeter.

HTH,
Paul

--

"Jackie Pearce" wrote in message
...
i'm trying to split data which is seperated by line breaks into seperate
columns. line breaks are not in the standard delimiter list and i cant
find a
way or doing this.

ie
John Smith
23 Tree Terrace
London
SW3
email
tel 01483 522563


any suggestions please! thanks

--
Jackie Pearce