incrementing letters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top