Leetcode•Oct 17, 2025
Excel Sheet Column Number
Hazrat Ali
Leetcode
Given a string columnTitle that represents the column title as appears in an Excel sheet, return its corresponding column number.
For example:
A -> 1 B -> 2 C -> 3 ... Z -> 26 AA -> 27 AB -> 28 ...
Example 1:
Input: columnTitle = "A" Output: 1
Example 2:
Input: columnTitle = "AB" Output: 28
Example 3:
Input: columnTitle = "ZY" Output: 701
Solution
/**
* @param {string} columnTitle
* @return {number}
*/
var titleToNumber = function(columnTitle) {
let result = 0;
for (let i = 0; i < columnTitle.length; i++) {
let value = columnTitle.charCodeAt(i) - 'A'.charCodeAt(0) + 1;
result = result * 26 + value;
}
return result;
};
console.log(titleToNumber("A"));
console.log(titleToNumber("AB"));
console.log(titleToNumber("ZY"));