View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
genkate23 genkate23 is offline
external usenet poster
 
Posts: 1
Default text lines to rows & columns

I would like to do text to columns with data that is set up in lines:

Albright, John C.
Spouse: Amy Knupp
Marriage Date: Nov 22, 1841
Location: Union Co., Illinois
Source: Family History Library, Salt Lake City, UT Microfilm: 963179



Albright, John F.
Spouse: Louisa Judy
Marriage Date: Jun 15, 1848
Location: Tazewell Co., Illinois
Source: Family History Library, Salt Lake City, UT Microfilm: 1314687

I would like to end up with each paragraph being on a single row, each line
contained on a single cell.

Thanks