Excel 2010- What does this formula mean and how does it work

[dangoodwin1]

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

[macropod]

The "AA101 " part of the formula simply outputs "AA101 ". Fairly simple.
The next part, which could be reduced to "&CHAR(ROW()+64)" takes the row number, adds 64 to it, then expresses that as as ASCII character. Everything's sweet if you don't want more than 26 rows.

At its simplest, you can get the sequence expressed in the second part of your post by changing the first part of the formula, so it becomes:
="A000 1A1"&CHAR(ROW()+64)

If you're wanting something more sophisticated than that, you'll need to say exactly what you require.