Column Letter to Index
Convert a column letter to a column index. Note that Google Sheets indices are 1-based and NOT 0-based. Return value will be 1-based.
Inputs
|
In Column Letter
String
|
The column letter you wish to convert to a column index. |
Outputs
|
Return Value
Integer
|
The index of the column. Returns -1 on error. Note that Google Sheets indices are 1-based and NOT 0-based, so this will never return 0. |