Mailing Labels to Spreadsheet.

[J. Michael]

I have seen this question before but am unable to find the message.

I have a MS Word document in address label format. I would like
to convert this file to a spread sheet. How do I do this?

Thanks

Michael

[Eva]

Copy and paste in Ms Excel
Eva

[David McRitchie]

That's a start but you then have to put each line into a column.

See
Text to Columns, Split at LF (line=feed character) (#lf)
where each label is in one cell (macro in the topic after #lf)
http://www.mvps.org/dmcritchie/excel/snakecol.htm#lf

Creating a Table from something like a column of address labels (#snkAddr)
where there is a definite number of rows per label
http://www.mvps.org/dmcritchie/excel...ol.htm#snkAddr
macro code in
http://www.mvps.org/dmcritchie/excel/code/naddr3ss.txt

to install and use a macro see
http://www.mvps.org/dmcritchie/excel....htm#havemacro

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Eva" <Accbee@gmail.com> wrote in message news:1146003267.563767.58850@e56g2000cwe.googlegroups.com...
> Copy and paste in Ms Excel
> Eva
>