View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jackie Pearce Jackie Pearce is offline
external usenet poster
 
Posts: 2
Default how to split data where line breaks are the delimiter

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