here's a function somebody wrote. just paste in into a code module. then in
a cell, enter the formula with the column number like so:

=getcollet(256)

returns IV


Function GetCoLLet(ColNumber As Integer) As String
GetCoLLet = Left(Cells(1, ColNumber).Address(False, False), _
1 - (ColNumber 26))
End Function



--

Gary Keramidas
Excel 2003


"Tigerxxx" wrote in message
...
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.