But to actually print the labels, I would use Word to merge Excel data. For
help on Word mail merge using Excel as the data source have a look here
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm
http://www.mvps.org/word/FAQs/MailMe...ateADataSource
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"williamr" wrote in message
...
Thank You Very Much!!!
"Elkar" wrote:
You could try something like:
="Work Card # "&ROW()&" of 5000"
HTH,
Elkar
"williamr" wrote:
I want create 5000 labels using Excel. In row 1 I want "Work Card # 1
of
5000" and in row 2, "Work Card # 2 of 5000". How is this done?
Thanks