Search

Convert Column Letter To Number

Articles

Use this function to convert the specified column letter to a number, for example, A to 1, B to 2, AB to 28 etc.

Syntax

Convert Column Letter To Number (column_letter)

Parameters

Input Parameter Name Description
column_letter Column Letter

Returns

Return value Description
Number Returns the column letter as a number

Sample

Convert Column Letter To Number (AA) = 27

  • Converts the column letter AA to a number.
    Returns the number 27.

To view all the Excel functions, click here.

Did you find what you were looking for?