Its an array formula (CSE), so you need to press ctrl-shift-enter instead of enter.
Version for 0 or more spaces allowed
=IFERROR(SUM((LARGE(CODE(MID(UPPER(A1),ROW(OFFSET(A1,,,MAX(16,LEN(A1)),1)),1)),ROW(OFFSET(A1,,,MAX(16,LEN(A1)),1)))=CODE(MID("TSSSRPMLIIHECCAA"&REPT(" ",MAX(LEN(A1)-16,0)),ROW(OFFSET(A1,,,MAX(16,LEN(A1)),1)),1)))*1)=LEN(A1),FALSE)
Click to expand...