Assigning letters a specific value

Occasional Visitor

New to Excel. I'm trying to assign a basic number to letters that will allow me to total various sums.

 

Where would I begin?

1 Reply
You could use the CODE() function which will return a number for each letter. For example, "A" is 65, "B" is 66, "Z" is 90, etc.

https://support.microsoft.com/en-us/office/code-function-c32b692b-2ed0-4a04-bdd9-75640144b928?ns=exc...