Thread: convert column number to letter
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default 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!



Reply With QuoteReply With Quote