I want the various information to be captured in one cell
for each row of information. I will then take the info
in that one cell and put it into a text file.

-----Original Message-----
What do you mean by "document"? That's a Word term.
Excel has workbooks
consisting of one or more worksheets. Are you saying
that you want each row
transposed vertically to a new worksheet in the range
A1:A4 in that same
workbook?


--
Jim Rech
Excel MVP


.