Formula to convert word to numbers (A-Z = 1-26)

[RicardoCubed]

Looking for a formula to calculate numeric equivalent of a word, say "ATTITUDE" to the sum total of represented letters using the numeric equivalent.
For example: A T T I T U D E = 100
1+20+20+9+20+21+4+5

Would like formula to work for any length word.

A = 1
B = 2
etc

Appreciate help.

 

[Fluff]

What version of Excel are you using?
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Rick Rothstein]

Assuming all your text is always upper case, you can use this formula in any version of Excel, but in versions prior to XL365 or XL2021 you will have to commit the formula using CTRL+SHIFT+ENTER...

=SUM(IFERROR(CODE(MID(A1,ROW($1:$99),1))-64,0))

However, Fluff is correct... you should add your Excel version number to your profile (see his message for how to do it).

 

[Fluff]

If you have 2021 or 365 another, similar, option

Fluff.xlsm
	A	B
1
2	ATTITUDE	100
3	Hit	37
Data

Cell Formulas
Range	Formula
B2:B3	B2	=SUM(CODE(MID(UPPER(A2),SEQUENCE(LEN(A2)),1))-64)

 

[RicardoCubed]

If you have 2021 or 365 another, similar, option

Fluff.xlsm
	A	B
1
2	ATTITUDE	100
3	Hit	37
Data

Cell Formulas
Range	Formula
B2:B3	B2	=SUM(CODE(MID(UPPER(A2),SEQUENCE(LEN(A2)),1))-64)

Thanks much!!! Resolved.

 

[Fluff]

Glad we could help & thanks for the feedback.

Thanks also for updating your profile.