Forum Discussion
Assigning letters a specific value
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?
- 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=excel&version=90&syslcid=1033&uilcid=1033&appver=zxl900&helpid=xlmain11.chm60169&ui=en-us&rs=en-us&ad=us
