Second half of the problem first:

With 1A entered into cell A2, put this formula into cell A3 and fill it down
the sheet as far as you need:
=IF(RIGHT(A2,1)="C",VALUE(LEFT(A2,LEN(A2)-1))+1 &
"A",IF(RIGHT(A2,1)="A",LEFT(A2,1) &"B",LEFT(A2,1) & "C")

Remember that all of that is one formula, without an [enter] key in the
middle anywhere.

That should take care of your 1A, 1B, 1C, 2A, 2B, 2C ... problem.

Now for the Lesson 1... problem. If you have Lesson 1 in A2 and you have
Lesson 2 in A3, just select them both and then fill down, Excel is smart
enough to figure out that you want a series.

If your 1A, 1B, or Lesson # entries are spread out down the sheet, things
become a bit tougher. The solutions I've provided assume that each entry is
on the row below the last previous entry.
"T." wrote:

I homeschool my children and am in the process of setting up a grading book
for the year. I've got all my averages down, no problem. What I am having a
problem with is adding the lesson numbers or number/letter combination.
Instead of having to type each one in (Lesson 1, Lesson 2, etc) I would like
to have it auto populate the cells. When I type "Lesson 1" in the first
cell, I need it to fill in the "Lesson 2", "Lesson 3", etc.

With another book, the lessons are numbered and lettered. The first lesson
is 1A, 1B, 1C, then goes to 2A, 2B, 2C, etc.

Does anyone know how to make this happen?? I would appreciate any help
anyone can give... this is driving me nuts!!! LOL

Thanks so much!