how to formulate A..B..C...AA AB AC..etc

**xianwinwin** · 03-16-2011, 05:33 PM

This is a trivial but it drives me crazy.

I wish to have a list of alphabetical order as in:

A
B
C
D
...
AA
AB

--- the same way excel provides the header. My intuitive approach was
A2=A1+1 (where A1 was 'A') and drag it down - duhaa I get #Value.

Does anyone know how to do this?
thanks for any pointer

**Cutter** · 03-16-2011, 05:50 PM

See if this helps

http://www.excelfunctions.net/Excel-Char-Function.html

**shg** · 03-16-2011, 05:51 PM

In A1 and copy down,

=SUBSTITUTE(ADDRESS(1, ROW(), 4), "1", "")

**martindwilson** · 03-16-2011, 08:22 PM

try importing this text file to your custom lists tools/options/custom lists..import
then if you put say w in a1 x in a2 select and drag down you'll get
w
x
y
z
aa
ab
ac
ad
ae
af
same as using numbers