Convert column number to column letter

You can convert the column number into its corresponding column letter.

 A
1=SUBSTITUTE(ADDRESS(1,1,4),"1","") = A
2=SUBSTITUTE(ADDRESS(1,2,4),"1","") = B
3=SUBSTITUTE(ADDRESS(1,3,4),"1","") = C
4=SUBSTITUTE(ADDRESS(1,26,4),"1","") = Z
5=SUBSTITUTE(ADDRESS(1,52,4),"1","") = AZ

Built-in Functions

ADDRESS - The cell reference given a row and column number.
SUBSTITUTE - The text string after replacing instances of a substring.


VBA Code

Col_Letter - VBA equivalent


Related Formulas

Convert column letter to column number


© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top