Auto input column letter headings for columns > "Z" in Excel
Posted on 2011-03-13
In Excel (2007), I have been using the following formula to generate letters (rather than numbers) to represent particular columns:
However, that method is only useful for columns A-Z. Beginning with column AA, the formula returns non-alphabetic symbols.
Is there a different formula which generates column letters but does so for all columns rather than just the first 26?