Could that formula be modifed so after 26 characters, it started with A1,
B1... instead of AA, AB...?
Thanks so much!

"PCLIVE" wrote:

There are probably several ways to do this. Here is a formula you can use.

=LEFT(ADDRESS(1,ROW(1:1),4),1)

Drag down as needed.
If you will be using more than 26 characters, then:

=IF(LEN(ADDRESS(1,ROW(1:1),4))=3,LEFT(ADDRESS(1,RO W(1:1),4),2),LEFT(ADDRESS(1,ROW(1:1),4),1))

HTH,
Paul

--

"rayybay" wrote in message
...
Is there a way to automatic number in Excel using letters instead of
numbers?
I tried doing A, B, C in the first three boxes and then using the "+" to
make
it continue, but it repeats A, B, C...A, B, C instead. Any ideas?
thanks!