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 NUMBE...
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.
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.