Knowledge.ToString()

Excel Column Letter to Number Quick Reference

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 LetterColumn Number
A1
B2
C3
D4
E5
F6
G7
H8
I9
J10
K11
L12
M13
N14
O15
P16
Q17
R18
S19
T20
U21
V22
W23
X24
Y25
Z26

Excel Columns AA-AZ

Column LetterColumn Number
AA27
AB28
AC29
AD30
AE31
AF32
AG33
AH34
AI35
AJ36
AK37
AL38
AM39
AN40
AO41
AP42
AQ43
AR44
AS45
AT46
AU47
AV48
AW49
AX50
AY51
AZ52

Excel Columns BA-BZ

Column LetterColumn Number
BA53
BB54
BC55
BD56
BE57
BF58
BG59
BH60
BI61
BJ62
BK63
BL64
BM65
BN66
BO67
BP68
BQ69
BR70
BS71
BT72
BU73
BV74
BW75
BX76
BY77
BZ78

Excel Columns CA-CZ

Column LetterColumn Number
CA79
CB80
CC81
CD82
CE83
CF84
CG85
CH86
CI87
CJ88
CK89
CL90
CM91
CN92
CO93
CP94
CQ95
CR96
CS97
CT98
CU99
CV100
CW101
CX102
CY103
CZ104

Excel Columns DA-DZ

Column LetterColumn Number
DA105
DB106
DC107
DD108
DE109
DF110
DG111
DH112
DI113
DJ114
DK115
DL116
DM117
DN118
DO119
DP120
DQ121
DR122
DS123
DT124
DU125
DV126
DW127
DX128
DY129
DZ130

Excel Columns EA-EZ

Column LetterColumn Number
EA131
EB132
EC133
ED134
EE135
EF136
EG137
EH138
EI139
EJ140
EK141
EL142
EM143
EN144
EO145
EP146
EQ147
ER148
ES149
ET150
EU151
EV152
EW153
EX154
EY155
EZ156

Excel Columns FA-FZ

Column LetterColumn Number
FA157
FB158
FC159
FD160
FE161
FF162
FG163
FH164
FI165
FJ166
FK167
FL168
FM169
FN170
FO171
FP172
FQ173
FR174
FS175
FT176
FU177
FV178
FW179
FX180
FY181
FZ182

Excel Columns GA-GZ

Column LetterColumn Number
GA183
GB184
GC185
GD186
GE187
GF188
GG189
GH190
GI191
GJ192
GK193
GL194
GM195
GN196
GO197
GP198
GQ199
GR200
GS201
GT202
GU203
GV204
GW205
GX206
GY207
GZ208

Excel Columns HA-HZ

Column LetterColumn Number
HA209
HB210
HC211
HD212
HE213
HF214
HG215
HH216
HI217
HJ218
HK219
HL220
HM221
HN222
HO223
HP224
HQ225
HR226
HS227
HT228
HU229
HV230
HW231
HX232
HY233
HZ234

Excel Columns IA-IZ

Column LetterColumn Number
IA235
IB236
IC237
ID238
IE239
IF240
IG241
IH242
II243
IJ244
IK245
IL246
IM247
IN248
IO249
IP250
IQ251
IR252
IS253
IT254
IU255
IV256
IW257
IX258
IY259
IZ260

Excel Columns JA-JZ

Column LetterColumn Number
JA261
JB262
JC263
JD264
JE265
JF266
JG267
JH268
JI269
JJ270
JK271
JL272
JM273
JN274
JO275
JP276
JQ277
JR278
JS279
JT280
JU281
JV282
JW283
JX284
JY285
JZ286

Excel Columns KA-KZ

Column LetterColumn Number
KA287
KB288
KC289
KD290
KE291
KF292
KG293
KH294
KI295
KJ296
KK297
KL298
KM299
KN300
KO301
KP302
KQ303
KR304
KS305
KT306
KU307
KV308
KW309
KX310
KY311
KZ312

Excel Columns LA-LZ

Column LetterColumn Number
LA313
LB314
LC315
LD316
LE317
LF318
LG319
LH320
LI321
LJ322
LK323
LL324
LM325
LN326
LO327
LP328
LQ329
LR330
LS331
LT332
LU333
LV334
LW335
LX336
LY337
LZ338

Excel Columns MA-MZ

Column LetterColumn Number
MA339
MB340
MC341
MD342
ME343
MF344
MG345
MH346
MI347
MJ348
MK349
ML350
MM351
MN352
MO353
MP354
MQ355
MR356
MS357
MT358
MU359
MV360
MW361
MX362
MY363
MZ364

Excel Columns NA-NZ

Column LetterColumn Number
NA365
NB366
NC367
ND368
NE369
NF370
NG371
NH372
NI373
NJ374
NK375
NL376
NM377
NN378
NO379
NP380
NQ381
NR382
NS383
NT384
NU385
NV386
NW387
NX388
NY389
NZ390

Excel Columns OA-OZ

Column LetterColumn Number
OA391
OB392
OC393
OD394
OE395
OF396
OG397
OH398
OI399
OJ400
OK401
OL402
OM403
ON404
OO405
OP406
OQ407
OR408
OS409
OT410
OU411
OV412
OW413
OX414
OY415
OZ416

Excel Columns PA-PZ

Column LetterColumn Number
PA417
PB418
PC419
PD420
PE421
PF422
PG423
PH424
PI425
PJ426
PK427
PL428
PM429
PN430
PO431
PP432
PQ433
PR434
PS435
PT436
PU437
PV438
PW439
PX440
PY441
PZ442

Excel Columns QA-QZ

Column LetterColumn Number
QA443
QB444
QC445
QD446
QE447
QF448
QG449
QH450
QI451
QJ452
QK453
QL454
QM455
QN456
QO457
QP458
QQ459
QR460
QS461
QT462
QU463
QV464
QW465
QX466
QY467
QZ468

Excel Columns RA-RZ

Column LetterColumn Number
RA469
RB470
RC471
RD472
RE473
RF474
RG475
RH476
RI477
RJ478
RK479
RL480
RM481
RN482
RO483
RP484
RQ485
RR486
RS487
RT488
RU489
RV490
RW491
RX492
RY493
RZ494

Excel Columns SA-SZ

Column LetterColumn Number
SA495
SB496
SC497
SD498
SE499
SF500
SG501
SH502
SI503
SJ504
SK505
SL506
SM507
SN508
SO509
SP510
SQ511
SR512
SS513
ST514
SU515
SV516
SW517
SX518
SY519
SZ520

Excel Columns TA-TZ

Column LetterColumn Number
TA521
TB522
TC523
TD524
TE525
TF526
TG527
TH528
TI529
TJ530
TK531
TL532
TM533
TN534
TO535
TP536
TQ537
TR538
TS539
TT540
TU541
TV542
TW543
TX544
TY545
TZ546

Excel Columns UA-UZ

Column LetterColumn Number
UA547
UB548
UC549
UD550
UE551
UF552
UG553
UH554
UI555
UJ556
UK557
UL558
UM559
UN560
UO561
UP562
UQ563
UR564
US565
UT566
UU567
UV568
UW569
UX570
UY571
UZ572

Excel Columns VA-VZ

Column LetterColumn Number
VA573
VB574
VC575
VD576
VE577
VF578
VG579
VH580
VI581
VJ582
VK583
VL584
VM585
VN586
VO587
VP588
VQ589
VR590
VS591
VT592
VU593
VV594
VW595
VX596
VY597
VZ598

Excel Columns WA-WZ

Column LetterColumn Number
WA599
WB600
WC601
WD602
WE603
WF604
WG605
WH606
WI607
WJ608
WK609
WL610
WM611
WN612
WO613
WP614
WQ615
WR616
WS617
WT618
WU619
WV620
WW621
WX622
WY623
WZ624

Excel Columns XA-XZ

Column LetterColumn Number
XA625
XB626
XC627
XD628
XE629
XF630
XG631
XH632
XI633
XJ634
XK635
XL636
XM637
XN638
XO639
XP640
XQ641
XR642
XS643
XT644
XU645
XV646
XW647
XX648
XY649
XZ650

Excel Columns YA-YZ

Column LetterColumn Number
YA651
YB652
YC653
YD654
YE655
YF656
YG657
YH658
YI659
YJ660
YK661
YL662
YM663
YN664
YO665
YP666
YQ667
YR668
YS669
YT670
YU671
YV672
YW673
YX674
YY675
YZ676

Excel Columns ZA-ZZ

Column LetterColumn Number
ZA677
ZB678
ZC679
ZD680
ZE681
ZF682
ZG683
ZH684
ZI685
ZJ686
ZK687
ZL688
ZM689
ZN690
ZO691
ZP692
ZQ693
ZR694
ZS695
ZT696
ZU697
ZV698
ZW699
ZX700
ZY701
ZZ702

Share

Comments

30 responses to “Excel Column Letter to Number Quick Reference”

  1. Eric Swartwout Avatar
    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 If

    If Asc(chr2) >= 65 And Asc(chr2) <= 90 Then
    letnum = Asc(chr2) – 64 + (trips * 26)
    End If

    ElseIf 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 If

    Else
    letnum = “error”
    End If

    End Function

  2. Yolanda Basson Avatar
    Yolanda Basson

    How do I change the column names back to letters instead of numbers?

    1 2 3 4 5
    2
    3
    4
    5

    But want it to be

    A B C D E
    1
    2
    3
    4
    5

    1. Vishal Monpara Avatar
      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 Monpara

  3. Thomas Avatar
    Thomas

    Still the most useful reference, since manually computing it takes much longer. 🙂

  4. Gilberto Avatar
    Gilberto

    Thank you!!

  5. holibut Avatar
    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 for

    return columnValue
    # end def

    # test

    getExcelColumnNumber(‘AA’) # 27
    getExcelColumnNumber(‘YA’) # 651
    getExcelColumnNumber(‘ZZ’) # 702
    “`

  6. Scott Avatar
    Scott

    Thanks from New Zealand. 🙂

  7. Conrad Graybill Avatar
    Conrad Graybill

    Thanks! What a timesaver. Just found this for the first after manually calculating the column numbers for VLOOKUP function.

  8. Dee Roche Avatar
    Dee Roche

    =column() in a column will render the column number

  9. Mateja Avatar
    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])+1

    print(o)

  10. Yoyo At The Beach Avatar
    Yoyo At The Beach

    Thanks from the Cayman Islands for this!
    You saved me a lot of time working on my vlookups ✌✌✌

  11. Jonathan Avatar
    Jonathan

    Thank you for this! I’ve visited this page many times when working on VLOOKUPs. Total life saver.

  12. Jameel Siddiq Avatar
    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

  13. Dirk Avatar
    Dirk

    Thank you, such a simple table but very, very helpful.

  14. Stephen Allen Avatar
    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

  15. Courtney Avatar
    Courtney

    Thank you so much! This is so helpful 🙂

  16. Oj Shrivastava Avatar
    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.

    1. VIPUL JHAVERI Avatar
      VIPUL JHAVERI

      very brilliant
      thanks to share
      vipul jhaveri

  17. Martin Avatar
    Martin

    you should stop using vlookup and use xlookup. There you can just reference “CH” instead of 86

  18. Tim Avatar
    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!

  19. Vipul Avatar
    Vipul

    Thank you. what a time saver

  20. Nick Avatar
    Nick

    Superb and very helpful reference

  21. Aditi Bhatt Avatar
    Aditi Bhatt

    Thanks, it helped!

  22. Ravinga Avatar
    Ravinga

    Thank you! Helpful

  23. leonora Avatar
    leonora

    fabulous a real time saver thankyou!

  24. Andrew Harichandran Avatar
    Andrew Harichandran

    Thank you, Mr. Vishal Monpara!

  25. Natasha Avatar
    Natasha

    Thank you so much for this. It’s such a simple thing, but it’s so very helpful.

  26. Chris Avatar
    Chris

    Thank you that’s very useful. I use this list everyday at work.

  27. Katie Avatar
    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.

  28. Abhilash Nagkat Avatar
    Abhilash Nagkat

    Can you also provide the Column# for column till AAA or so?

Leave a Reply

Your email address will not be published. Required fields are marked *