A1 Cell to Column and Row Indices
Convert a cell from A1 Notation to a column index and row index. Note that Google Sheets indices are 1-based and NOT 0-based. Output values will be 1-based.
Inputs
|
In
Exec
|
|
|
In Cell
String
|
The single cell you wish to convert, expressed in A1 notation. Please do not put a range into InCell. |
Outputs
|
Out
Exec
|
|
|
Out Column Index
Integer
|
|
|
Out Row Index
Integer
|
|
|
Return Value
Boolean
|
Whether or not a conversion is possible. Fails immediately if a range is input. |