DataText to ColumnsDelimited byOther........CTRL + j and OK


Gord Dibben MS Excel MVP

On Fri, 22 Aug 2008 05:50:00 -0700, Jackie Pearce
wrote:

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