Excel Column Title to Number | Dataford Interview Questions

Given an Excel column title, write a program to return its corresponding number. The title contains one or more uppercase letters from A through Z, where A = 1, B = 2, ..., Z = 26, AA = 27, and so on. Implement title_to_number(column_title), returning an integer.

Example: "AB" returns 28 because 1 * 26 + 2 = 28. Example: "ZY" returns 701 because 26 * 26 + 25 = 701.

Constraints: 1 <= len(column_title) <= 7, and every character is an uppercase English letter.

Constraints

1 <= len(column_title) <= 7
column_title contains only uppercase English letters from A through Z
The result fits within a standard signed 32-bit integer

Function Signature

def title_to_number(column_title):

Your question is Excel Column Title to Number. Start with the requirements in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Example: "AB" returns 28 because 1 * 26 + 2 = 28. Example: "ZY" returns 701 because 26 * 26 + 25 = 701.

Constraints: 1 <= len(column_title) <= 7, and every character is an uppercase English letter.

Constraints

1 <= len(column_title) <= 7
column_title contains only uppercase English letters from A through Z
The result fits within a standard signed 32-bit integer

Function Signature

def title_to_number(column_title):

Your question is Excel Column Title to Number. Start with the requirements in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.