GEMATRIA CALCULATION ON EXCEL

[MisEagle]

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 NUMBER IS SUMMED UP AND ONCE NUMBERS ARE PUT IN, A WORD IN RELATION TO THE NUMBER IS THE OUTPUT?

[#2]

@MisEagle 

Please provide some examples of the expected input and output, preferably in the form of a sample workbook.

(And turn off the CAPS LOCK - thanks!)

[#3]

You can use the formulas CHAR(Number) to retrieve the number as per ASC II and vice-versa using the formula CODE("Letter")
CHAR(65)=A
CODE("A")=65

To make it work as you said, will be necessary you organise your input data, because both formulas are limited to the ASC II table /codification.
If the input is a "word" instead a letter, will be necessary split each letter of the word.
The same for a number.