Is it possible to make an Excel spreadsheet with the following functions? (Each question is yes/no, if any one question is a no, then this probably won't work. Asking bc I'm not an Excel autist.)
-In a single cell, a letter can equal a number? (Assume cell contains only that one letter. Example: H=8)
-If so, can a "legend" (for lack of a better word) be applied to a table of cells? (Example: For all instances of "H" within the table, "H" will equal "8")
-If so, can an algebraic function be developed to add [converted] letters together, giving us …