Column name instead of number
Combining the ADDRESS, LEFT and FIND function can return the alpha column Id
from the row and column numbers.
Check out the parameters in Help. Note that I used the
Absolute row; relative column parameter in ADDRESS so there is only the one
$ sign preceding the row number for the FIND.
=LEFT(ADDRESS(4,32,2),FIND("$",ADDRESS(4,32,2),1)-1)
--
Regards,
OssieMac
"Gary Keramidas" wrote:
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.
|