GAS – Convert Column Index to Letter

Straight up, I am not taking any credit for this, as it is all played out well enough on stackoverflow.

Column Index to Letter

That said, my two favourites:

for scripting:

actually on a sheet as use of inbuilt functions:

This has flexibility, I have used it to get the column letter from another sheet. You can also replace “COLUMN()” with a cell reference, which either by entering a number or the result of a formula will return the letter from the column.

Leave a Reply

Your email address will not be published. Required fields are marked *