Export E-mail addresses from text document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PEPPER AND LOLA - 25 May 2005 23:25 GMT

I am using Microsoft Office Word. I have a document that has unset feilds
exactly as follows. I'd like to convert this labled information from the
document to an excel spreadsheet. I think I need to set feilds?

Name:
City,
Phone:
e-mail address:

Reply to this Message

Michael_Corral - 26 May 2005 01:11 GMT

I would use Find and Replace (Ctrl+H) to insert a tab maker between the
fields or where you want them to be and then copy all and paste into Excel.
The tabs tell Excel the data following the tab is to go into the next cell in
the adjacent column, a paragraph marker tells it to go to the next row. Now
go to the very top and make your column headers, be sure that the headers are
a different font size and formatting from the rest of the data to let Excel
know what are the headers and what is the data.

Signature

Top Notch Admin

> I am using Microsoft Office Word. I have a document that has unset feilds
> exactly as follows. I'd like to convert this labled information from the
[quoted text clipped - 4 lines]
> Phone:
> e-mail address:

Reply to this Message

Graham Mayor - 26 May 2005 06:22 GMT

If I understand you requirements correctly, then select the column and from
the table menu > convert > text to table. Pick the number of columns to
match the number of lines that form each 'record' plus any space between
them.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I am using Microsoft Office Word. I have a document that has unset
> fields exactly as follows. I'd like to convert this label
[quoted text clipped - 5 lines]
> Phone:
> e-mail address:

Reply to this Message