Skip to content

Instantly share code, notes, and snippets.

@Digi92
Digi92 / getNameFromNumber
Last active May 13, 2021 07:51
This function will convert a number to an excel-like column name. For example: 1 => A 2 => B 27 => AA 28 => AB 14558 => UMX URL: https://stackoverflow.com/questions/3302857/algorithm-to-get-the-excel-like-column-name-of-a-number#answer-3302991
<?php
function getNameFromNumber($num) {
$numeric = $num % 26;
$letter = chr(65 + $numeric);
$num2 = intval($num / 26);
if ($num2 > 0) {
return $this->getNameFromNumber($num2 - 1) . $letter;
} else {
return $letter;
function letterFromNumber = function( number ) {
var letter = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'.charAt(number % 26)
var concat = Math.round(number / 26);
return concat > 0 ? letterFromNumber(concat-1) + letter : letter;
};