MS Excel
Here is a quick reference for Excel column letter to number mapping. Many times I needed to find the column number associated with a column letter in order to use it in Excel Macro. For a lazy developer like me, It is very time consuming đ to use my Math skill to get the answer so I created this quick reference lookup for myself.
Jump to specific column list
If you are looking for a specific column, click on the following links to jump to a specific list of columns
Columns A-Z (1-26)
Columns AA-AZ (27-52)
Columns BA-BZ (53-78)
Columns CA-CZ (79-104)
Columns DA-DZ (105-130)
Columns EA-EZ (131-156)
Columns FA-FZ (157-182)
Columns GA-GZ (183-208)
Columns HA-HZ (209-234)
Columns IA-IZ (235-260)
Columns JA-JZ (261-286)
Columns KA-KZ (287-312)
Columns LA-LZ (313-338)
Column MA-MZ (339-364)
Columns NA-NZ (365-390)
Columns OA-OZ (391-416)
Columns PA-PZ (417-442)
Columns QA-QZ (443-468)
Columns RA-RZ (469-494)
Columns SA-SZ (495-520)
Columns TA-TZ (521-546)
Columns UA-UZ (547-572)
Columns VA-VZ (573-598)
Columns WA-WZ (599-624)
Columns XA-XZ (625-650)
Columns YA-YZ (651-676)
Columns ZA-ZZ (677-702)
Excel Columns A-Z
Column Letter | Column Number |
---|---|
A | 1 |
B | 2 |
C | 3 |
D | 4 |
E | 5 |
F | 6 |
G | 7 |
H | 8 |
I | 9 |
J | 10 |
K | 11 |
L | 12 |
M | 13 |
N | 14 |
O | 15 |
P | 16 |
Q | 17 |
R | 18 |
S | 19 |
T | 20 |
U | 21 |
V | 22 |
W | 23 |
X | 24 |
Y | 25 |
Z | 26 |
Excel Columns AA-AZ
Column Letter | Column Number |
---|---|
AA | 27 |
AB | 28 |
AC | 29 |
AD | 30 |
AE | 31 |
AF | 32 |
AG | 33 |
AH | 34 |
AI | 35 |
AJ | 36 |
AK | 37 |
AL | 38 |
AM | 39 |
AN | 40 |
AO | 41 |
AP | 42 |
AQ | 43 |
AR | 44 |
AS | 45 |
AT | 46 |
AU | 47 |
AV | 48 |
AW | 49 |
AX | 50 |
AY | 51 |
AZ | 52 |
Excel Columns BA-BZ
Column Letter | Column Number |
---|---|
BA | 53 |
BB | 54 |
BC | 55 |
BD | 56 |
BE | 57 |
BF | 58 |
BG | 59 |
BH | 60 |
BI | 61 |
BJ | 62 |
BK | 63 |
BL | 64 |
BM | 65 |
BN | 66 |
BO | 67 |
BP | 68 |
BQ | 69 |
BR | 70 |
BS | 71 |
BT | 72 |
BU | 73 |
BV | 74 |
BW | 75 |
BX | 76 |
BY | 77 |
BZ | 78 |
Excel Columns CA-CZ
Column Letter | Column Number |
---|---|
CA | 79 |
CB | 80 |
CC | 81 |
CD | 82 |
CE | 83 |
CF | 84 |
CG | 85 |
CH | 86 |
CI | 87 |
CJ | 88 |
CK | 89 |
CL | 90 |
CM | 91 |
CN | 92 |
CO | 93 |
CP | 94 |
CQ | 95 |
CR | 96 |
CS | 97 |
CT | 98 |
CU | 99 |
CV | 100 |
CW | 101 |
CX | 102 |
CY | 103 |
CZ | 104 |
Excel Columns DA-DZ
Column Letter | Column Number |
---|---|
DA | 105 |
DB | 106 |
DC | 107 |
DD | 108 |
DE | 109 |
DF | 110 |
DG | 111 |
DH | 112 |
DI | 113 |
DJ | 114 |
DK | 115 |
DL | 116 |
DM | 117 |
DN | 118 |
DO | 119 |
DP | 120 |
DQ | 121 |
DR | 122 |
DS | 123 |
DT | 124 |
DU | 125 |
DV | 126 |
DW | 127 |
DX | 128 |
DY | 129 |
DZ | 130 |
Excel Columns EA-EZ
Column Letter | Column Number |
---|---|
EA | 131 |
EB | 132 |
EC | 133 |
ED | 134 |
EE | 135 |
EF | 136 |
EG | 137 |
EH | 138 |
EI | 139 |
EJ | 140 |
EK | 141 |
EL | 142 |
EM | 143 |
EN | 144 |
EO | 145 |
EP | 146 |
EQ | 147 |
ER | 148 |
ES | 149 |
ET | 150 |
EU | 151 |
EV | 152 |
EW | 153 |
EX | 154 |
EY | 155 |
EZ | 156 |
Excel Columns FA-FZ
Column Letter | Column Number |
---|---|
FA | 157 |
FB | 158 |
FC | 159 |
FD | 160 |
FE | 161 |
FF | 162 |
FG | 163 |
FH | 164 |
FI | 165 |
FJ | 166 |
FK | 167 |
FL | 168 |
FM | 169 |
FN | 170 |
FO | 171 |
FP | 172 |
FQ | 173 |
FR | 174 |
FS | 175 |
FT | 176 |
FU | 177 |
FV | 178 |
FW | 179 |
FX | 180 |
FY | 181 |
FZ | 182 |
Excel Columns GA-GZ
Column Letter | Column Number |
---|---|
GA | 183 |
GB | 184 |
GC | 185 |
GD | 186 |
GE | 187 |
GF | 188 |
GG | 189 |
GH | 190 |
GI | 191 |
GJ | 192 |
GK | 193 |
GL | 194 |
GM | 195 |
GN | 196 |
GO | 197 |
GP | 198 |
GQ | 199 |
GR | 200 |
GS | 201 |
GT | 202 |
GU | 203 |
GV | 204 |
GW | 205 |
GX | 206 |
GY | 207 |
GZ | 208 |
Excel Columns HA-HZ
Column Letter | Column Number |
---|---|
HA | 209 |
HB | 210 |
HC | 211 |
HD | 212 |
HE | 213 |
HF | 214 |
HG | 215 |
HH | 216 |
HI | 217 |
HJ | 218 |
HK | 219 |
HL | 220 |
HM | 221 |
HN | 222 |
HO | 223 |
HP | 224 |
HQ | 225 |
HR | 226 |
HS | 227 |
HT | 228 |
HU | 229 |
HV | 230 |
HW | 231 |
HX | 232 |
HY | 233 |
HZ | 234 |
Excel Columns IA-IZ
Column Letter | Column Number |
---|---|
IA | 235 |
IB | 236 |
IC | 237 |
ID | 238 |
IE | 239 |
IF | 240 |
IG | 241 |
IH | 242 |
II | 243 |
IJ | 244 |
IK | 245 |
IL | 246 |
IM | 247 |
IN | 248 |
IO | 249 |
IP | 250 |
IQ | 251 |
IR | 252 |
IS | 253 |
IT | 254 |
IU | 255 |
IV | 256 |
IW | 257 |
IX | 258 |
IY | 259 |
IZ | 260 |
Excel Columns JA-JZ
Column Letter | Column Number |
---|---|
JA | 261 |
JB | 262 |
JC | 263 |
JD | 264 |
JE | 265 |
JF | 266 |
JG | 267 |
JH | 268 |
JI | 269 |
JJ | 270 |
JK | 271 |
JL | 272 |
JM | 273 |
JN | 274 |
JO | 275 |
JP | 276 |
JQ | 277 |
JR | 278 |
JS | 279 |
JT | 280 |
JU | 281 |
JV | 282 |
JW | 283 |
JX | 284 |
JY | 285 |
JZ | 286 |
Excel Columns KA-KZ
Column Letter | Column Number |
---|---|
KA | 287 |
KB | 288 |
KC | 289 |
KD | 290 |
KE | 291 |
KF | 292 |
KG | 293 |
KH | 294 |
KI | 295 |
KJ | 296 |
KK | 297 |
KL | 298 |
KM | 299 |
KN | 300 |
KO | 301 |
KP | 302 |
KQ | 303 |
KR | 304 |
KS | 305 |
KT | 306 |
KU | 307 |
KV | 308 |
KW | 309 |
KX | 310 |
KY | 311 |
KZ | 312 |
Excel Columns LA-LZ
Column Letter | Column Number |
---|---|
LA | 313 |
LB | 314 |
LC | 315 |
LD | 316 |
LE | 317 |
LF | 318 |
LG | 319 |
LH | 320 |
LI | 321 |
LJ | 322 |
LK | 323 |
LL | 324 |
LM | 325 |
LN | 326 |
LO | 327 |
LP | 328 |
LQ | 329 |
LR | 330 |
LS | 331 |
LT | 332 |
LU | 333 |
LV | 334 |
LW | 335 |
LX | 336 |
LY | 337 |
LZ | 338 |
Excel Columns MA-MZ
Column Letter | Column Number |
---|---|
MA | 339 |
MB | 340 |
MC | 341 |
MD | 342 |
ME | 343 |
MF | 344 |
MG | 345 |
MH | 346 |
MI | 347 |
MJ | 348 |
MK | 349 |
ML | 350 |
MM | 351 |
MN | 352 |
MO | 353 |
MP | 354 |
MQ | 355 |
MR | 356 |
MS | 357 |
MT | 358 |
MU | 359 |
MV | 360 |
MW | 361 |
MX | 362 |
MY | 363 |
MZ | 364 |
Excel Columns NA-NZ
Column Letter | Column Number |
---|---|
NA | 365 |
NB | 366 |
NC | 367 |
ND | 368 |
NE | 369 |
NF | 370 |
NG | 371 |
NH | 372 |
NI | 373 |
NJ | 374 |
NK | 375 |
NL | 376 |
NM | 377 |
NN | 378 |
NO | 379 |
NP | 380 |
NQ | 381 |
NR | 382 |
NS | 383 |
NT | 384 |
NU | 385 |
NV | 386 |
NW | 387 |
NX | 388 |
NY | 389 |
NZ | 390 |
Excel Columns OA-OZ
Column Letter | Column Number |
---|---|
OA | 391 |
OB | 392 |
OC | 393 |
OD | 394 |
OE | 395 |
OF | 396 |
OG | 397 |
OH | 398 |
OI | 399 |
OJ | 400 |
OK | 401 |
OL | 402 |
OM | 403 |
ON | 404 |
OO | 405 |
OP | 406 |
OQ | 407 |
OR | 408 |
OS | 409 |
OT | 410 |
OU | 411 |
OV | 412 |
OW | 413 |
OX | 414 |
OY | 415 |
OZ | 416 |
Excel Columns PA-PZ
Column Letter | Column Number |
---|---|
PA | 417 |
PB | 418 |
PC | 419 |
PD | 420 |
PE | 421 |
PF | 422 |
PG | 423 |
PH | 424 |
PI | 425 |
PJ | 426 |
PK | 427 |
PL | 428 |
PM | 429 |
PN | 430 |
PO | 431 |
PP | 432 |
PQ | 433 |
PR | 434 |
PS | 435 |
PT | 436 |
PU | 437 |
PV | 438 |
PW | 439 |
PX | 440 |
PY | 441 |
PZ | 442 |
Excel Columns QA-QZ
Column Letter | Column Number |
---|---|
QA | 443 |
QB | 444 |
QC | 445 |
QD | 446 |
QE | 447 |
QF | 448 |
QG | 449 |
QH | 450 |
QI | 451 |
QJ | 452 |
QK | 453 |
QL | 454 |
QM | 455 |
QN | 456 |
QO | 457 |
QP | 458 |
459 | |
QR | 460 |
QS | 461 |
QT | 462 |
QU | 463 |
QV | 464 |
QW | 465 |
QX | 466 |
QY | 467 |
QZ | 468 |
Excel Columns RA-RZ
Column Letter | Column Number |
---|---|
RA | 469 |
RB | 470 |
RC | 471 |
RD | 472 |
RE | 473 |
RF | 474 |
RG | 475 |
RH | 476 |
RI | 477 |
RJ | 478 |
RK | 479 |
RL | 480 |
RM | 481 |
RN | 482 |
RO | 483 |
RP | 484 |
RQ | 485 |
RR | 486 |
RS | 487 |
RT | 488 |
RU | 489 |
RV | 490 |
RW | 491 |
RX | 492 |
RY | 493 |
RZ | 494 |
Excel Columns SA-SZ
Column Letter | Column Number |
---|---|
SA | 495 |
SB | 496 |
SC | 497 |
SD | 498 |
SE | 499 |
SF | 500 |
SG | 501 |
SH | 502 |
SI | 503 |
SJ | 504 |
SK | 505 |
SL | 506 |
SM | 507 |
SN | 508 |
SO | 509 |
SP | 510 |
SQ | 511 |
SR | 512 |
SS | 513 |
ST | 514 |
SU | 515 |
SV | 516 |
SW | 517 |
SX | 518 |
SY | 519 |
SZ | 520 |
Excel Columns TA-TZ
Column Letter | Column Number |
---|---|
TA | 521 |
TB | 522 |
TC | 523 |
TD | 524 |
TE | 525 |
TF | 526 |
TG | 527 |
TH | 528 |
TI | 529 |
TJ | 530 |
TK | 531 |
TL | 532 |
TM | 533 |
TN | 534 |
TO | 535 |
TP | 536 |
TQ | 537 |
TR | 538 |
TS | 539 |
TT | 540 |
TU | 541 |
TV | 542 |
TW | 543 |
TX | 544 |
TY | 545 |
TZ | 546 |
Excel Columns UA-UZ
Column Letter | Column Number |
---|---|
UA | 547 |
UB | 548 |
UC | 549 |
UD | 550 |
UE | 551 |
UF | 552 |
UG | 553 |
UH | 554 |
UI | 555 |
UJ | 556 |
UK | 557 |
UL | 558 |
UM | 559 |
UN | 560 |
UO | 561 |
UP | 562 |
UQ | 563 |
UR | 564 |
US | 565 |
UT | 566 |
UU | 567 |
UV | 568 |
UW | 569 |
UX | 570 |
UY | 571 |
UZ | 572 |
Excel Columns VA-VZ
Column Letter | Column Number |
---|---|
VA | 573 |
VB | 574 |
VC | 575 |
VD | 576 |
VE | 577 |
VF | 578 |
VG | 579 |
VH | 580 |
VI | 581 |
VJ | 582 |
VK | 583 |
VL | 584 |
VM | 585 |
VN | 586 |
VO | 587 |
VP | 588 |
VQ | 589 |
VR | 590 |
VS | 591 |
VT | 592 |
VU | 593 |
VV | 594 |
VW | 595 |
VX | 596 |
VY | 597 |
VZ | 598 |
Excel Columns WA-WZ
Column Letter | Column Number |
---|---|
WA | 599 |
WB | 600 |
WC | 601 |
WD | 602 |
WE | 603 |
WF | 604 |
WG | 605 |
WH | 606 |
WI | 607 |
WJ | 608 |
WK | 609 |
WL | 610 |
WM | 611 |
WN | 612 |
WO | 613 |
WP | 614 |
WQ | 615 |
WR | 616 |
WS | 617 |
WT | 618 |
WU | 619 |
WV | 620 |
WW | 621 |
WX | 622 |
WY | 623 |
WZ | 624 |
Excel Columns XA-XZ
Column Letter | Column Number |
---|---|
XA | 625 |
XB | 626 |
XC | 627 |
XD | 628 |
XE | 629 |
XF | 630 |
XG | 631 |
XH | 632 |
XI | 633 |
XJ | 634 |
XK | 635 |
XL | 636 |
XM | 637 |
XN | 638 |
XO | 639 |
XP | 640 |
XQ | 641 |
XR | 642 |
XS | 643 |
XT | 644 |
XU | 645 |
XV | 646 |
XW | 647 |
XX | 648 |
XY | 649 |
XZ | 650 |
Excel Columns YA-YZ
Column Letter | Column Number |
---|---|
YA | 651 |
YB | 652 |
YC | 653 |
YD | 654 |
YE | 655 |
YF | 656 |
YG | 657 |
YH | 658 |
YI | 659 |
YJ | 660 |
YK | 661 |
YL | 662 |
YM | 663 |
YN | 664 |
YO | 665 |
YP | 666 |
YQ | 667 |
YR | 668 |
YS | 669 |
YT | 670 |
YU | 671 |
YV | 672 |
YW | 673 |
YX | 674 |
YY | 675 |
YZ | 676 |
Excel Columns ZA-ZZ
Column Letter | Column Number |
---|---|
ZA | 677 |
ZB | 678 |
ZC | 679 |
ZD | 680 |
ZE | 681 |
ZF | 682 |
ZG | 683 |
ZH | 684 |
ZI | 685 |
ZJ | 686 |
ZK | 687 |
ZL | 688 |
ZM | 689 |
ZN | 690 |
ZO | 691 |
ZP | 692 |
ZQ | 693 |
ZR | 694 |
ZS | 695 |
ZT | 696 |
ZU | 697 |
ZV | 698 |
ZW | 699 |
ZX | 700 |
ZY | 701 |
ZZ | 702 |
Share
Comments
30 responses to âExcel Column Letter to Number Quick Referenceâ
Eric Swartwout
call this function with letters to convert to number or numbers to convert to letters
Function letnum(Ref As Variant) As Variant
Dim up As String
Dim chr1 As String âfirst character
Dim chr2 As String âsecond character
Dim trips As Long â trips through alphabet
Dim asc2 As Variant âsecond letterâcheck to see if parameter is letter or number
If IsNumeric(Ref) = False Then
trips = 0
up = UCase(Ref)
âlook for one or 2 characters
If Len(up) = 2 Then
chr1 = Left(up, 1)
chr2 = Right(up, 1)
trips = Asc(chr1) â 64
ElseIf Len(up) = 1 Then
chr2 = up
End IfIf Asc(chr2) >= 65 And Asc(chr2) <= 90 Then
letnum = Asc(chr2) â 64 + (trips * 26)
End IfElseIf IsNumeric(Ref) = True And Ref 26 Then
If Ref Mod 26 > 0 Then
asc2 = Chr((Ref Mod 26) + 64)
letnum = Chr((Ref \ 26) + 64) & asc2
Else
asc2 = Chr(90)
letnum = Chr((Ref \ 26) + 63) & asc2
End If
Else
letnum = Chr(Ref + 64)
End IfElse
letnum = âerrorâ
End IfEnd Function
Reply
Yolanda Basson
How do I change the column names back to letters instead of numbers?
1 2 3 4 5
2
3
4
5But want it to be
A B C D E
1
2
3
4
5Reply
Vishal Monpara
Hi Yolanda,
You may have R1C1 Reference style enabled. That is the reason, it is showing all numbers. In order to change it, go to File menu > Options > Formulas tab > under âWorking with Formulasâ section, you will see âR1C1 Reference styleâ checked. Uncheck this box and you will get all your columns in alphabets.
Regards
Vishal MonparaReply
Thomas
Still the most useful reference, since manually computing it takes much longer. đ
Reply
Gilberto
Thank you!!
Reply
holibut
You can change column name to number by programming. The following is in Python:
â`
def getExcelColumnNumber(columnName):
# columnName as A, AA, ABC
columnLetters = list(columnName)
print(columnLetters)columnValue = 0
lettersCount = len(columnLetters)
for i in range(lettersCount):
columnValue = columnValue + 26**(lettersCount -i-1) * (ord(columnLetters[i]) â 64)
# end forreturn columnValue
# end def# test
getExcelColumnNumber(âAAâ) # 27
getExcelColumnNumber(âYAâ) # 651
getExcelColumnNumber(âZZâ) # 702
â`Reply
Scott
Thanks from New Zealand. đ
Reply
Conrad Graybill
Thanks! What a timesaver. Just found this for the first after manually calculating the column numbers for VLOOKUP function.
Reply
Dee Roche
=column() in a column will render the column number
Reply
Mateja
or you can just make a simple script that takes an input (such as ABD, ABCDEFG, etc) and returns the #
s, o, l = input(), 0, list(âABCDEFGHIJKLMNOPQRSTUVWXYZâ)
for i in range(len(s)):
o*=26
o+=l.index(s[i])+1print(o)
Reply
Yoyo At The Beach
Thanks from the Cayman Islands for this!
You saved me a lot of time working on my vlookups âââReply
Jonathan
Thank you for this! Iâve visited this page many times when working on VLOOKUPs. Total life saver.
Reply
Jameel Siddiq
brilliant job, I often need the reverse but your table gives me that option as I can just look up the other way
Reply
Dirk
Thank you, such a simple table but very, very helpful.
Reply
Stephen Allen
I agree that this is really useful. I have take the opportunity to extend the process to Column XFD â the last in my version of Excel.
A copy of the VB Code is available at https://www.linkedin.com/feed/update/urn:li:activity:6644160098514141186
Reply
Courtney
Thank you so much! This is so helpful đ
Reply
Oj Shrivastava
Or you can just make quick Mathematical formula based on the position of input.
eg.
ABC: 26*26*(A=1) + 26*(B=2) + (C=3) = 731.
CH: 26*(C=3) + (H=8) = 86.Reply
VIPUL JHAVERI
very brilliant
thanks to share
vipul jhaveriReply
Martin
you should stop using vlookup and use xlookup. There you can just reference âCHâ instead of 86
Reply
Tim
Thank you! I ran out of fingers trying to figure out how to reference Column CH in my VLOOKUP. đ
So simple and yet so usefulâbless you, Mr. Monpara!Reply
Vipul
Thank you. what a time saver
Reply
Nick
Superb and very helpful reference
Reply
Aditi Bhatt
Thanks, it helped!
Reply
Ravinga
Thank you! Helpful
Reply
leonora
fabulous a real time saver thankyou!
Reply
Andrew Harichandran
Thank you, Mr. Vishal Monpara!
Reply
Natasha
Thank you so much for this. Itâs such a simple thing, but itâs so very helpful.
Reply
Chris
Thank you thatâs very useful. I use this list everyday at work.
Reply
Katie
Thank you! The formulas elsewhere online (eg â=COLUMN(INDIRECT(B5&â1âł))â) work just fine, but imo itâs a bit more efficient to just use a list sometimes.
Reply
Abhilash Nagkat
Can you also provide the Column# for column till AAA or so?
Reply