Bonni:
What Graham says is indeed the solution in my opinion. In addition,
however, you may need some creativity to make it work for you. If you
convert Text to Table you need to be sure that the end of the record is
marked w/ a hard return and the fields within a record are TABs. You
can then import into Excel smoothly, manipulate columns (remove, change
order, ...) and save the file as a *.csv.
The creativity comes in to get tabs and hard returns appropriately. If
all fields in a record are separated by hard returns too, getting it
into Excel will not help you as all fields are in one column. If you
have no paragraph breaks (except for the last which Word adds by
default), then you need to find a way to automatically create end of
record breaks. This could be TWO consecutive Line breaks, or any other
unique separating series of characters. (Line breaks can be replaced by
tabs, by Replace ^l (small "L") by ^t). Otherwise, assuming you dont
have two e-mail addresses in one record, you could replace the @ by @^p
so the record splits in the middle of the e-mail address. Now yr
records are "skewed", but in a repeated, consistent pattern so can be
fixed in Excel (the email address can be restored w/ CONCATENATE.)
I hope this all makes sense and that you can get it working.
Henk