Convert column letter to column number:

Please enter this formula: =COLUMN(INDIRECT("AB1")) into a blank cell where you want to locate the converted result, and then press Enter key to get the column number:

Note: In the above formula, AB is the column letter that you want to get the column number based on, you can change it to your need.

Convert column number to column letter:

Please type this formula: =SUBSTITUTE(ADDRESS(1,200,4),1,"") into a blank cell to get the result, and then press Enter to get the column letter as follows:

Note: In the above formula, the red number 200 is the column number that you want to convert to column letter, you can change it to your need.

Convert column letter to column number:

1. Hold down the ALT + F11 keys, then it opens the Microsoft Visual Basic for Applications window.

2. Click Insert > Module, and paste the following code in the Module Window.

VBA code: convert column letter to column number:

Public Function ToColNum(ColN)
    ToColNum = Range(ColN & 1).Column
End Function

3. Then save and close this code, go back to the worksheet, and enter this formula: =Tocolnum("VV") (VV is the column letter that you want to convert number. ) into a blank cell, and press Enter key to get the column number, see screenshot:

Convert column number to column letter:

1. Hold down the ALT + F11 keys, then it opens the Microsoft Visual Basic for Applications window.

2. Click Insert > Module, and paste the following code in the Module Window.

VBA code: convert column number to column letter:

Public Function ToColletter(Collet)
    ToColletter = Split(Cells(1, Collet).Address, "$")(1)
End Function

3. Then save and close this code, go back to the worksheet, and enter this formula: =ToColletter(50) (50 is the column number that you want to convert to letter. ) into a blank cell, and press Enter key to get the column number, see screenshot: