Column name instead of number

  • Thread starter Thread starter Tigerxxx
  • Start date Start date
T

Tigerxxx

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.
 
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
 
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)
 
Back
Top