Where you show (return) is that actually a paragraph ¶ or just a manual line
break?
To get rid of the Home:, Work: and Email:, you can use EditReplace the
replace each of them in turn with nothing.
Just what you need to do will depend a bit on the answer to the first
question above, but see "Convert Labels into Mail Merge Data File" on fellow
MVP Graham Mayor's website at:
http://www.gmayor.com/convert_labels...mail_merge.htm
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
"
wrote in message ...
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