ExcelBanter - convert column number to letter

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - convert column number to letter (https://www.excelbanter.com/excel-programming/343718-re-convert-column-number-letter.html)

lvcha.gouqizi

convert column number to letter

sorry for the confusion. Thanks a lot, it works!

Tom Ogilvy

convert column number to letter

A bit less intense: If the column number is in A1

=LEFT(ADDRESS(ROW(),A1,4,TRUE),1+(A126))

--
Regards,
Tom Ogilvy

"lvcha.gouqizi" wrote in message
oups.com...
sorry for the confusion. Thanks a lot, it works!

All times are GMT +1. The time now is 02:57 AM.