Code360 powered by Coding Ninjas X Naukri.com. Code360 powered by Coding Ninjas X Naukri.com

Excel Column Number

Easy
0/40
Average time to solve is 23m
profile
Contributed by
27 upvotes
Asked in companies
OracleAppleExpedia Group

Problem statement

You have been given a column title as appears in an Excel sheet, return its corresponding column number.

For example:
A -> 1
B -> 2
C -> 3
...
Z -> 26
AA -> 27
AB -> 28 
...
Detailed explanation ( Input/output format, Notes, Images )
Constraints:
1 <= |S| <= 10
Input contains only uppercase English Alphabet letters

Time Limit : 1 sec
Output Format
The only line of output will print the column number corresponding to given column title 
Sample Input 1
AB
Sample Output 1
28
Sample Input 2
ZZZ
Sample Output 2
18278
Full screen
Console