Breaking News: Grepper is joining You.com. Read the official announcement!

javascript alphabet to number

Add Answer

Web Surfer answered on August 12, 2020 Popularity 9/10 Helpfulness 6/10

answer javascript alphabet to number

related js int to alphabet

related alphabet to number javascript

javascript alphabet to number

Comment

/**
 * Converts a spreadsheet column letter to a number. eg. A -> 1
 * 
 * @param {String} str - (required) The spreadsheet column letter to convert to a number.
 * 
 * @returns {(Number|undefined)} The column number or undefined.
 */
function convertLetterToNumber(str) {
  if ((typeof str === "string" || str instanceof String) && /^[a-zA-Z]+$/.test(str)) {
    str = str.toUpperCase();
    let out = 0,
      len = str.length;
    for (pos = 0; pos < len; pos++) {
      out += (str.charCodeAt(pos) - 64) * Math.pow(26, len - pos - 1);
    }
    return out;
  } else {
    return undefined;
  }
}

convertLetterToNumber("A"); // 1
convertLetterToNumber("b"); // 2
convertLetterToNumber("Ba"); // 53
convertLetterToNumber("dE"); // 109
convertLetterToNumber("ZZZZ"); // 475254

convertLetterToNumber("A"); // 1
convertLetterToNumber("b"); // 2
convertLetterToNumber("Ba"); // 53
convertLetterToNumber("dE"); // 109
convertLetterToNumber("ZZZZ"); // 475254

Popularity 9/10 Helpfulness 6/10 Language javascript

Source: stackoverflow.com

Tags: alphabet excel javascript letter

Link to this answer
Share Copy Link

Contributed on Jan 12 2021

Web Surfer

0 Answers Avg Quality 2/10

Closely Related Answers

js int to alphabet

Comment

var value = 10;

document.write((value + 9).toString(36).toUpperCase());

Popularity 9/10 Helpfulness 5/10 Language javascript

Source: Grepper

Tags: alphabet alphabe

Link to this answer
Share Copy Link

Contributed on Aug 12 2020

7h0m4s

0 Answers Avg Quality 2/10

alphabet to number javascript

Comment

-1

str = 'z'
n = (str == str.toLowerCase()) ? 96 : 64
result = str.charCodeAt(0) - n
console.log(result);

Popularity 9/10 Helpfulness 1/10 Language javascript

Source: Grepper

Tags: alphabet alphabe

Link to this answer
Share Copy Link

Contributed on Sep 21 2021

Grotesque Gaur

0 Answers Avg Quality 2/10

javascript alphabet to number

Contents

More Related Answers

javascript alphabet to number

Closely Related Answers

js int to alphabet

alphabet to number javascript

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.