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