Convert letter to number in Excel and Google Sheets

=COLUMN(INDIRECT(A2&"1"))

A2 = data cell

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

Convert letter to number in Excel

How to convert letter to number in Excel?
Convert letter to number in Excel

CONVERT LETTER TO NUMBER — EXCEL SHEETS FORMULA AND EXAMPLE

=COLUMN(INDIRECT(A2&"1"))

  • A2 = data cell

Convert letter to number in Google Sheets

How to convert letter to number in Google Sheets?
Convert letter to number in Google Sheets

CONVERT LETTER TO NUMBER — GOOGLE SHEETS FORMULA AND EXAMPLE

=COLUMN(INDIRECT(A2&"1"))

  • A2 = data cell