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

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