Convert letter to a number in Google Sheets or Excel

How to convert an alphabet into a number string in Excel or Google Sheets?

FORMULA

=COLUMN(INDIRECT(A2&1))

If you want to convert an alphabet to a number this formula will help you extract the exact position of a given letter. For example, A has 1 and H has 7 position

The formula is compatible with Excel and Google Spreadsheet and will work on both.

Below how the result will look.

CONVERT CONVERT LETTER TO NUMBER IN GOOGLE SHEETS OR EXCEL

CONVERT CONVERT LETTER TO NUMBER IN GOOGLE SHEETS OR EXCEL