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



--

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.

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

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.

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

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