#171
Excel Sheet Column Number
pupil · 315 · lc easy +21 · verified · 67.3% accepted · 5,080 likes · top 73%
Description
Given a string columnTitle representing the column title as it appears in a spreadsheet, return its corresponding column number.
For example:
A -> 1
B -> 2
C -> 3
...
Z -> 26
AA -> 27
AB -> 28
...
Example 1:
A -> 1
B -> 2
C -> 3
...
Z -> 26
AA -> 27
AB -> 28
...
Example 2:
Input: columnTitle = "A"
Output: 1
Example 3:
Input: columnTitle = "AB"
Output: 28
Example 4:
Input: columnTitle = "ZY"
Output: 701
Code
1
2
3