Text + Numbers
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)ValuesOKEsc
Gord Dibben MS Excel MVP
On Fri, 17 Aug 2007 15:18:01 -0700, 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
|