GEMATRIA CALCULATION ON EXCEL

PLEASE HOW DO I CREATE A PIVOT TABLE OR SEARCH COLUMN THAT ALLOWS THE RELATION OF EACH LETTER OF THE ALPHABET TO A NUMBER.  EXAMPLE, A=1, B=2. C=3 AND SO ON. SUCH THAT WHEN ONE INPUTS A WORD, A NUMBE...