Column name instead of number
 

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.

Column name instead of number
 

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.

Column name instead of number
 

=CHAR(64+COLUMN(C5))


"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.

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.

Column name instead of number
 

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

Column name instead of number
 

Thank you all very much!

"Dave Peterson" wrote:

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