Rob said:

I was wondering if there is a way to make a formula increment to the next

letter character instead of the next number. For instance...

=IF(B3="","",A2+1) will give me 1, 2, 3, 4 etc...

=if(B3="", "", char(code(A2)+1))

or even add letters to the end?

=IF(B3="","",IF(B3<>B2,A2+1,A2&"a")) where A2 is either 0 or 1

=IF(B3="","",IF(B3<>B2,A2+1)) where A2 is either A or AA or 1A or A1

Sorry, but these do not make sense to me.

In the first formula, if A2 is 0 or 1, what is wrong with the A2+1 or

A2&"a"? The first will result in 1 or 2; the second will result in "0a" or

"1a". If that is not the result you want, exactly what result do you want?

In the second formula, A2+1 makes no sense if A2 is "A", "AA", "1A" or "A1".

And it makes no more sense to me in the context of your original question.

Again, exactly what result do you want?

PS: In the second formula, it is poor form to omit the "value_if_false"

part. Your formula will result in FALSE if B3 is not "" and B3=B2. If you

need help, it would be prudent to explain what result you want in that case,

too.

----- original message -----