#171 - Excel Sheet Column Number

Easy • View on LeetCode • View on GitHub

Problem Description

Given a string columnTitle that represents the column title as appears in an Excel sheet, return its corresponding column number.

Solution

/**
 * @param {string} columnTitle
 * @return {number}
 */
var titleToNumber = function(columnTitle) {
  return columnTitle.split('').reduce((result, c, i) => {
    return result + (c.charCodeAt() - 64) * Math.pow(26, columnTitle.length - (i + 1));
  }, 0);
};