[BoniM]

If the (return) you are showing is a line return - use Replace to replace all
manual line breaks with tab characters.
To do that, in the Replace dialog box, click the More button if available
(if you see less instead, you're already good to go). In the find what box,
click the Special button and choose Manual Line Break. Move your insertion
point to the Replace with box and choose Tab Character from the Special list
and then click Replace All. Select all of your data and use Convert Text to
Table to create a six column table with the data in the wrong order. Select
a column with the down pointing black arrow at the top of the column and the
drag the selected column to your prefered location.
Let me know if I can be further help or even if I'm just way off base... :-)


" wrote:

2-1-08

Hi,

I received a WORD 2003 document consisting of 500 + names, address and phone
numbers typed as:

First MI Last †’ Home: 213-456-7890 (return)
123 Main St †’ Work: 213-789-0456 (return)
City, ST ZIP †’ Email: me@mydomain ¶


How do I parse the three lines of information into one line per record in
the following format:

First MI Last Street Address City ST ZIP Home # Work #
Email

so I can convert the text to a table and then into a usable data file.


Thanks so much for your help.

Joanne