Text + Numbers

[Guest]

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

 

[Guest]

You could try something like:

="Work Card # "&ROW()&" of 5000"

HTH,
Elkar

 

[Guest]

Thank You Very Much!!!

You could try something like:

="Work Card # "&ROW()&" of 5000"

HTH,
Elkar

 

[Bernard Liengme]

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/MailMerge/CreateAMailMerge.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource

best wishes

 

[Gord Dibben]

In A1 enter ="Work Card # " & ROW() & " of 5000"

With A1 selected................

In NameBox type A1:A5000 and ENTER

Hit CTRL + D to copy down.

Copy column A and Paste Special(in place)>Values>OK>Esc


Gord Dibben MS Excel MVP