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

text lines to rows & columns
 

How about =A1&A2&A3&....
where A1, A2 ... are the cells with name, spaoce, etc

Copy this down the column to capture all data
Now you can use Copy followed by Paste Special to convert the formulas to
values, allwoing you to delete all the original data
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"genkate23" wrote in message
...
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