Excel alone is poorly suited for creating labels.

Do you have Word?

Use Word's mailmerge with Excel or Access as the data source.

Assuming you are using Word for the mailmerge and Excel for the source see
these sites for help.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm


Gord Dibben MS Excel MVP

On Wed, 2 Dec 2009 09:21:01 -0800, pcor
wrote:

I have app 400 names in Col B row 1 down to row 400 of my spreadsheet.
I would like to transfer that info to "paper labels"
Anyone know how?
Thanks