Get the Column Letter in Microsoft Excel The File I used to make these videos is available for download: SP-tipsTutsAndNotes-getColumnLetterExcel-episode-getColumnLetterDetailedDownload This tutorial was designed to teach how to build a nested formula that returns the column letter of the cell where the formula is executed. This function can be saved as a named formula and used in other, more complex formulas that require the knowledge of the column letter.