Hey guys,
I recently had a problem of getting excel to detect a pattern with letters at the end. eg:
AA101 A
AA101 B
AA101 C ... and so on.

I got given this formula but not sure how it works or if I were to change the sequence how I would go about editing it.
The formula i got given is: ="AA101 "&CHAR(ROWS(A$1:A1)+64)

Can someone explain how this formula works?

And also if I were to change the sequence to (example):
A000 1A1A
A000 1A1B
A000 1A1C
How would I go about changing the formula??

thanks is advance