Is there an easy way to output a cell column letter if I have the column number?
For example, in cell B2 I would like to have a formula that looks at cell B3, which has a value of, say, 29 in it. Then B2's formula generates the letter of the 29th column - "AC" in this case. How can I do this with a formula without involving VB?
I've used
=SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1","") to generate a long string of column letters, and then used a look up function to look up the letter based on desired column number, but that's a bit cumbersome.
Thank you
Bookmarks