inverse of the column function? i.e. input a number, output theco
Shane Devenshire wrote...
And to take the last simplification and go further:
from
=LEFT(ADDRESS(1,A1,2),LEN(ADDRESS(1,A1))-3)
to
2007:
=LEFT(ADDRESS(1,A1,2),1+(A126)+(A1702))
2003:
=LEFT(ADDRESS(1,A1,2),1+(A126))
....
You could use the 2007 formula in 2003. As long as A1 contains a valid
column number (between 1 and 256), the (A1702) test will be FALSE. No
good reason to use different formulas in different Excel versions when
it isn't necessary.
Then again, if some future Excel versions goes beyond columns ZZZ, as
long as the ADDRESS function remains unchanged, it'd be more robust to
use
=SUBSTITUTE(ADDRESS(1,A1,4),"1","")
This ain't rocket science.
|