BTW - FWIW,

None of these formula solutions will *automatically* work (be imported) into
Custom Lists.
You have to clear the formulas from the cells before XL will accept them
into a list.

Now, the OP asked for A ... Z

I think keying in 26 letters down a column *AIN'T* really that difficult.

What do you think?<bg
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"Max" wrote in message
...
Duke, thanks. The slightly longer versions were to make it a little more
robust, in case new rows / columns are inserted above / left of the starting
cell subsequently. It's something I picked up here along the way, which has
since got a little "stuck-on" as a personal practice, I guess <g
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Duke Carey" <duke_No_Junk_carey_at_hotmail.com wrote in message
...
Max -

Just a little shorter version of each
=CHAR(ROW(A1)+64)
=CHAR(COLUMN(A1)+64)