Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inverse of the column function? i.e. input a number, output thecorresponding column text label | Excel Worksheet Functions | |||
How do I turn excel columns from column number to column letter? | Setting up and Configuration of Excel | |||
Count number of cells and total in one column, based on another column suffix | Excel Worksheet Functions | |||
Display missing Part Number if Column A does not match column B | Excel Worksheet Functions | |||
Auto number w/ different letter-number combos in same column | Excel Worksheet Functions |