One more way:

="A"&TEXT(INT((ROW()-1)/4)+1,"000")
in A1 and drag down.

Rowf wrote:

I am trying to create a quick and dirty Serial Number list to load into Avery.

I need to create a serial number list that goes something will repeat the
same line 4 times (Cell A1:A4) and then move up sequentially in Cells A5:A8,
without having to manually type it in, ie:

A001
A001
A001
A001
A002
A002
A002
A002
A003
etc
Any and all help would be greatly appreciated, thanks!

--

Dave Peterson