top of page

Excel Sheet Column Number

Given a string columnTitle that represents the column title as appear 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


  • 1 <= columnTitle.length <= 7

  • columnTitle consists only of uppercase English letters.

  • columnTitle is in the range ["A", "FXSHRXW"].


class Solution {
    public int titleToNumber(String columnTitle) {
        if(columnTitle==null) return -1;
        int sum=0;
        for(char c: columnTitle.toCharArray())
        return sum;

24 views0 comments

Recent Posts

See All

Minimum Deletions to Make Character Frequencies Unique

A string s is called good if there are no two different characters in s that have the same frequency. Given a string s, return the minimum number of characters you need to delete to make s good. The f

Smallest String With A Given Numeric Value

The numeric value of a lowercase character is defined as its position (1-indexed) in the alphabet, so the numeric value of a is 1, the numeric value of b is 2, the numeric value of c is 3, and so on.

bottom of page