showing results for - "javascript excel column letter to number"
María
22 Oct 2019
1function convertLetterToNumber(str) {
2  str = str.toUpperCase();
3  let out = 0, len = str.length;
4  for (pos = 0; pos < len; pos++) {
5    out += (str.charCodeAt(pos) - 64) * Math.pow(26, len - pos - 1);
6  }
7  return out;
8}
9
10convertLetterToNumber("A"); // 1
11convertLetterToNumber("b"); // 2
12convertLetterToNumber("Ba"); // 53
13convertLetterToNumber("dE"); // 109
14convertLetterToNumber("ZZZZ"); // 475254
queries leading to this page
js number to alphabet valueconvert number in alphabet to number in javascripthow to get alphabets using numbers in javascriptturning alphabetical order into numbers in javascriptturn number to alphabet jswork out value of alphabet in javascriptfunction in javascript convert alphabet to numberjavascript convert number to alphabetdoes js have the alphabet values available convert alphabetic string to number jsnumber to alphabet javascripthow to store numeric equivalent of letters in javascripthow to convert alphabet into number in jsjavascript letter valuesnumeric value for alphabets jshow to turn a letter of the alphabet into its number javascriptjavascript alphabet to numberjavascript convert alphabet into numbersalphabet letter to number javascriptnumber to alphabet jsget alphabet number from letter javascriptjs convert number to alphabetjs letter representation in numbersjavascript convert number to column like excelnumeric to alphabet jsalphabet to int jsjavascript convert letters to 23javascript alphabet numbertext to integer by alphabet javascripta to z corresponding numbers in javascriptjs letters numbersnumbers and alphabet char code jsalphabet to number javascriptjs number to alphabetconverting string alphabet characters to integer in javascripthow to convert number to alphabet in javascriptconvert alphabet to number javascriptconvert number to alphabet jsjs alphabet to numberjavascript convert alphabet to numberget number to alphabet jsconvert alphabet to numbers jsconvert alphabet to number in javascriptjs alphabet amountconvert numbers to letters nodejsget lettle number jsget number to alphabet javascriptgetting number of alphabet javascriptcodosponding number alphabet jshow to convert alphabet to number in javascripthow to assign alphabet to numbers in jshow to change digits to letters in jsjava script numeric of a alphabetalphabet to numbers jsjs alphabet from numberlettervalue javascriptconvert number to excel column letter javascriptjavascript alphabetical convert string to numberstring to alphabet number javascriptjs convert alphabet to numberconvert number to alphabet javascriptjavascript numeric of a alphabetnumber capital n jshow to convert numbers into alphabet in javascriptnumber to column letter excel jshow to find alphabet number in javascriptalphabet as numbers jsjavascript excel column letter to number