Converted reference
?
Example: C5 → R5C3 | R5C3 → C5
Recent History
How It Works
A1 notation identifies cells by column letter and row number (e.g. C5 = column C, row 5). R1C1 notation uses numeric row and column indices (e.g. R5C3 = row 5, column 3).
To convert A1 → R1C1: the column letter is converted to its number (A=1, B=2, … Z=26, AA=27…), and the row number stays the same. C5 → column C = 3, row 5 → R5C3.
To convert R1C1 → A1: the column number is converted back to a letter, and the row number stays the same. R5C3 → col 3 = C, row 5 → C5.
R1C1 notation is especially useful when writing VBA macros, where it simplifies relative references and column arithmetic.