Formatting text from Word to Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Morgan Montague - 18 Oct 2007 04:45 GMT

I haven't been able to find a tool online via google searches that would
allow be to do the following conversion.

Take these 3 lines of text:

Last Name, First Name
Street Address
City, State, Zip

and allow me to paste them into Excel as Cell A, Cell B and Cell C
automatically. I have about 300 names and address on a document used for
mailing labels and I would like to import this data into a spreadsheet.

Thanks in advance

Reply to this Message

Graham Mayor - 18 Oct 2007 05:11 GMT

See http://www.gmayor.com/convert_labels_into_mail_merge.htm and jump in
where the process matches your document.

Signature

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

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

> I haven't been able to find a tool online via google searches that
> would allow be to do the following conversion.
[quoted text clipped - 10 lines]
> spreadsheet.
> Thanks in advance

Reply to this Message

Morgan Montague - 18 Oct 2007 14:39 GMT

Thank you. This procedure looks like it may do exactly what I am looking
for. Thanks again.

> See http://www.gmayor.com/convert_labels_into_mail_merge.htm and jump in
> where the process matches your document.
[quoted text clipped - 13 lines]
>> spreadsheet.
>> Thanks in advance

Reply to this Message