How to Make a Letter Equal a Number in Excel | A=1, B=2 etc

Microsoft Excel Tips and Tricks

In this video I demonstrate how to convert a letter into a number, so for example A will become 1 and B will become 2. This method works for upper and lower case letters.

Credit Chester Tugwell