In A1 enter ="181" & CHAR(ROW(A65))

Copy down to A26


Gord Dibben MS Excel MVP


On Thu, 18 Sep 2008 10:08:01 -0700, Gi wrote:

I used to use this method to fill; however, it is no longer working for me in
Excel 2003. I wanted to auto-fill from 181A to 181Z and entered the first 4
cells. After highlighting cells 181A to 181D and dragging the little square
down, all I received was 181A to 181D in repeats. Can you help please?

"Sloth" wrote:

Enter the first two entries
Highlight the two entries
Drag the little square (at the bottom right of your selection) down to as
many is needed
Excel should continue the series you started.

"Nommer" wrote:

I am using Excel 2003. I am trying to set up a series of claim numbers they
look something like this: 0129H01, 0129H02, 0129H03,..., 0129H99. Is there a
fast way for me to create a series in excel for this list of claims instead
of just entering them all in one by one?