Forum Discussion
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 NUMBER IS SUMMED UP AND ONCE NUMBERS ARE PUT IN, A WORD IN RELATION TO THE NUMBER IS THE OUTPUT?
2 Replies
- 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. 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!)
