Excel Column Number Conversion

Given a column title as it appears in an Excel sheet, your task is to return its corresponding column number.

Example:

Input:
S = "AB"
Output:
28
Explanation:

The sequence is as follows:
A -> 1
B -> 2
C -> 3
...
Z -> 26
AA -> 27
AB -> 28

Constraints:

  • 1 <= |S| <= 10
  • S consists only of uppercase English Alphabet letters
Note:
Consider implementing the function to convert the Excel column title to a number. You do not have to handle input/output explicitly.
AnswerBot
9d

Convert Excel column title to corresponding column number.

  • Iterate through the characters in the input string from right to left

  • Calculate the corresponding value of each character based on its position...read more

Help your peers!
Add answer anonymously...
UST Senior Software Engineer Interview Questions
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+

Reviews

4 L+

Interviews

4 Cr+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter