Last Updated: Mar 15, 2021
Use this function to convert the specified column letter to a number, for example, A to 1, B to 2, AB to 28 etc.
Convert Column Letter To Number (column_letter)
| Input Parameter Name | Description | 
|---|---|
| column_letter | Column Letter | 
| Return value | Description | 
|---|---|
| Number | Returns the column letter as a number | 
Convert Column Letter To Number (AA) = 27
To view all the Excel functions, click here.