Excel Sheet Column Number LeetCode solution in JavaScript
1/**2* @param {string} columnTitle3* @return {number}4*/5var titleToNumber = function (columnTitle) {6/*7one letter: result between 1-26.8two letter: result between 26^1 + 1 -> 26^2 + digit. 27 - 702. All the combinations of A-Z and A-Z.9*/1011let sum = 0;12for (let letter of columnTitle) {13let d = letter.charCodeAt(0) - "A".charCodeAt(0) + 1;14sum = sum * 26 + d;15}1617return sum;18};