Learn
Practice
Interview
Resources
Newsletter
F
Toggle theme
0
F
0
Toggle menu
Animations
← Back to All Animations
Excel Sheet Column Title
Bookmark
Input
1 → "A"
28 → "AB"
701 → "ZY"
26 → "Z"
52 → "AZ"
Custom
columnNumber
=
1
columnNumber
1
Convert column 1 to its Excel title
columnNumber
1
Convert column 1 to its Excel title
columnNumber
1
result = ""
columnNumber
1
columnNumber
1
> 0
columnNumber
0
1 − 1 =
0
(shift to 0-indexed)
columnNumber
0
0 mod 26 =
0
columnNumber
0
'A' +
0
=
'A'
A
0
columnNumber
0
0 ÷ 26 =
0
(next digit)
A
0
columnNumber
0
columnNumber
0
= 0, stop
A
0
columnNumber
0
reverse →
"A"
A
columnNumber
0
A
1 → "A"
algo
master
.
io
Step:
Start: convert column number 1 to an Excel title
0 / 9
Input
1 → "A"
28 → "AB"
701 → "ZY"
26 → "Z"
52 → "AZ"
Custom
columnNumber
=
1
0 / 9
algo
master
.
io
Step:
Start: convert column number 1 to an Excel title
