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
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 QQ 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
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])+1
print(o)
Thanks from the Cayman Islands for this!
You saved me a lot of time working on my vlookups ✌✌✌
Thank you for this! I’ve visited this page many times when working on VLOOKUPs. Total life saver.
brilliant job, I often need the reverse but your table gives me that option as I can just look up the other way
Thank you, such a simple table but very, very helpful.
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
Thank you so much! This is so helpful 🙂
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.
very brilliant
thanks to share
vipul jhaveri
you should stop using vlookup and use xlookup. There you can just reference “CH” instead of 86
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!
Thank you. what a time saver
Superb and very helpful reference
Thanks, it helped!
Thank you! Helpful
fabulous a real time saver thankyou!
Thank you, Mr. Vishal Monpara!
Thank you so much for this. It’s such a simple thing, but it’s so very helpful.
Thank you that’s very useful. I use this list everyday at work.
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.
Can you also provide the Column# for column till AAA or so?