Export E-mail addresses from text document

P

PEPPER AND LOLA

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:
 
M

Michael_Corral

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.
 
G

Graham Mayor

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.

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top