Bit of a mouthful but this works
=LEFT(ADDRESS(ROW(A1),ROW(),2),FIND("$",ADDRESS(RO W(A1),ROW(),2))-1)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"carl" wrote in message
...
I am trying to make a list like this:

A
B
C
.
.
Z
AA
AB

etc.

A Column List of all the Col's in a worksheet.

Is this possible ?

Thank you in advance.