In Google Sheets is there a simple way to convert a column index to the corresponding column letter? Absolutely. Here’s how you do it in two easy steps.
So, you’ve got a column index (e.g. 4 or 10 or whatever). And you want to turn that number into the corresponding column letter (e.g. D or J or whatever).
The first step is to use the ADDRESS function. The ADDRESS function returns a cell reference as a string. In other words, you feed it a row index and a column index, and it spits out the cell reference in A1 notation. If all you want is the column letter name, then any row index will do. Let’s use 1. And then you pass your column index to the second parameter of the ADDRESS function.
=ADDRESS(1, 10)By default, the ADDRESS function will give you the absolute cell reference. In other words, it will add the dollar signs before the column letter and row number.
$J$1Since we just want the column letter, we’d rather not have those pesky dollar signs. Fortunately, the ADDRESS function accepts a third parameter that lets you specify whether you want the absolute or relative reference.
We want the relative reference for both the column and the row. So, we’ll set the third parameter to 4.
=ADDRESS(1, 10, 4)J1Now we’re getting somewhere. All that’s left to do is get rid of the row number. We know that the row number is always going to be “1” (because we set the row index to the static value of 1). So, to get rid of the number 1, we can just use the SUBSTITUTE function.
=SUBSTITUTE(ADDRESS(1, 10, 4), 1, "")JAnd there you have it. You’ve now gotten your column letter from the column index. Awesome.