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
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)