powered by
Converts a spreadsheet column in A1 notation to an integer. "A" is 1, "B" is 2, ..., "Z" is 26 and "AA" is 27.
A1
"A"
1
"B"
2
"Z"
26
"AA"
27
col2int(x)
An integer column label (or NULL if x is NULL)
NULL
x
A character vector
col2int(LETTERS)
Run the code above in your browser using DataLab