Another way:
=substitute(address(1,column(c5),4),1,"")



Tigerxxx wrote:

Hello,

Can I write a formula which will give me the alphabets of a column i.e.
currently if I write teh formula "=column(c5)". then I get 3 which represents
"c".
Is there a way to get the resullt as "c" (preferably without writing a macro)?

Thank you.

--

Dave Peterson