incrementing letters

M

me

hello everyon

is there a way to increment letters without having to huge custom list

i.

000 = AA
001 = AA
002 = AA
ET

Thanks in advanc
 
A

Andy B

Hi

It depends how you want the outcome. You could use

="AA"&CHAR(63+ROW())
and fill down to increment. You need a more complex formula to advance the
second A, or change the formula each time to suit.

Andy.
 
Top