Excel Sheet Column Title Easy 0 attempts
LeetCode ↗

Excel Sheet Column Title

Easy MatrixBFSDFS LeetCode

Excel labels columns A, B, …, Z, then AA, AB, …, then AAA, and so on. You get a positive integer columnNumber where 1 means A, 2 means B, …, 26 means Z, 27 means AA. Return the column title string.

This is a base-26 style encoding, but note it is 1-based, not 0-based like plain binary.

Example 1

  • Input: columnNumber = 1
  • Output: "A"

Example 2

  • Input: columnNumber = 28
  • Output: "AB"

Example 3

  • Input: columnNumber = 701
  • Output: "ZY"

Constraints

  • 1 <= columnNumber <= 2^31 - 1
Sample Input
—
Sample Output
—
Constraints
  • 1 <= columnNumber <= 2^31 - 1
Test Cases
Case 1
Args: [1] Expected: "A"
Case 2
Args: [28] Expected: "AB"
Case 3
Args: [701] Expected: "ZY"
Topics
MatrixBFSDFS

Base-26 Conversion

function convertToTitle(columnNumber) {
  let result = '';
  while (columnNumber > 0) {
    columnNumber--;
    result = String.fromCharCode(65 + (columnNumber % 26)) + result;
    columnNumber = Math.floor(columnNumber / 26);
  }
  return result;
}

Time: O(log n) | Space: O(1)

Saved in this browser only. Private to you.

JavaScript