COLUMNA() returns the letter(s) where as COLUMN() returns a number
column() is great, as usually we want the column NUMBER
BUT when you want the column LETTER(s), something like
could return it.
I know you can use
but it's pretty long-winded...
=COLUMN(AB1) returns 28
=COLUMNA(AB1) returns AB
Kenneth Barber commented
Use Excel tables (available on the Insert tab) and you'll never have to speak in terms of "column AB" again. With Excel tables, you give names to your columns, and you can refer to those instead.
A.C. WILSON commented
I use this a lot but have had to resort to UDFs, LetterToNumber() and NumberToLetter() from TheSpreadsheetGuru.com. In each case one specifies not the full cell address but the cell column letter, or the cell column number, no row involved.
Harlan, as stated in initial proposal, there is indeed a cumbersome alternative method. So regarding the time and efficiency saving being worth it, it comes down to how often you would use it.
I would obviously use it plenty more than you!
I'm not sure why its existence (which would save me plenty of time) would put an 'excessive burden' on you..?
Harlan Grove commented
=ADDRESS(1,COLUMN(AB1),4) returns "AB1", so SUBSTITUTE(ADDRESS(1,COLUMN(AB1),4),1,"") returns "AB". I realize 3 function calls are more than 1, but are 3 function calls for something as rarely needed as this an excessive burden?
Either in a new function as you specified: COLUMNA(), or a new info_type in cell function such as cell(colA,reference)