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

javascript number in alphabet

Add Answer

Web Surfer answered on October 25, 2020 Popularity 9/10 Helpfulness 4/10

answer javascript number in alphabet

related how to make an alphabet in javascript

related javascript alphabet to number

related alphabet to number javascript

javascript number in alphabet

Comment

/**
 * Convert a whole number that is more than zero to a spreadsheet column letters. eg. 1 -> A
 * Source: https://stackoverflow.com/questions/45787459/convert-number-to-alphabet-string-javascript/45787487
 * 
 * @param {Number} num - (required) The number to convert to a spreadsheet column letter. Must be greater than zero.
 *
 * @returns {(String|undefined)} The spreadsheet column letter or undefined.
 */
function numToSSColumnLetter(num) {
  let columnLetter = "",
    t;

  while (num > 0) {
    t = (num - 1) % 26;
    columnLetter = String.fromCharCode(65 + t) + columnLetter;
    num = (num - t) / 26 | 0;
  }
  return columnLetter || undefined;
}

numToSSColumn(0); // undefined
numToSSColumn(1); // A
numToSSColumn(26); // Z
numToSSColumn(-1); // undefined
numToSSColumn(27); // AA
numToSSColumn(475254); // ZZZZ

Popularity 9/10 Helpfulness 4/10 Language javascript

Source: stackoverflow.com

Tags: alphabet javascript spreadsheet

Link to this answer
Share Copy Link

Contributed on Dec 02 2020

Web Surfer

0 Answers Avg Quality 2/10

Closely Related Answers

how to make an alphabet in javascript

Comments(1)

// To get an array of letters from 'a' to 'z' in javascript.

let alphabet = 'abcdefghijklmnopqrstuvwxyz'.split('');

Popularity 10/10 Helpfulness 10/10 Language javascript

Source: Grepper

Tags: alphabet alphabe

Link to this answer
Share Copy Link

Contributed on Oct 25 2020

Caffeinated Developer

0 Answers Avg Quality 2/10

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 alphabe

Link to this answer
Share Copy Link

Contributed on Jan 12 2021

Web Surfer

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 number in alphabet

Contents

More Related Answers

javascript number in alphabet

Closely Related Answers

how to make an alphabet in javascript

javascript alphabet to number

alphabet to number javascript

Grepper

Documentation

Social

Legal

Contact

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