Leetcode•Jun 16, 2025
Excel Sheet Column Title
Hazrat Ali
Leetcode
Given an integer columnNumber, return its corresponding column title as it appears in an Excel sheet.
For example:
A -> 1 B -> 2 C -> 3 ... Z -> 26 AA -> 27 AB -> 28
Example 1:
Input: columnNumber = 1 Output: "A"
Example 2:
Input: columnNumber = 28 Output: "AB"
Example 3:
Input: columnNumber = 701 Output: "ZY"
Solution
/**
* @param {number} n
* @return {string}
*/
const convertToTitle = n => {
let title = '';
while (n > 0) {
n--;
title = String.fromCharCode(65 + (n % 26)) + title;
n = Math.floor(n / 26);
}
return title;
};