Excel How To Write Column Letter. When a reference is not provided, column returns the column number of the cell the formula resides in. Enter a1:a26 in the reference field, and then click ok.
Range (k & input no. Copy one of the following formulas, paste it into the active cell, and press the enter key to get the relative letter. Hence the result displayed is 7.
