A1 Range to Column and Row Indices
Convert a range 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 Range
String
|
The range you wish to convert, expressed in A1 notation. Please do not put a single cell into InRange. |
Outputs
|
Out
Exec
|
|
|
Out Column Start Index
Integer
|
|
|
Out Row Start Index
Integer
|
|
|
Out Column End Index
Integer
|
|
|
Out Row End Index
Integer
|
|
|
Return Value
Boolean
|
Whether or not a conversion is possible. Fails immediately if a range is input. |