Thread: Translate Column Index Num to Letter
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default Translate Column Index Num to Letter
On Thu, 7 Dec 2006 13:52:00 -0800, DJS wrote:

Looking for a quick and easy way to revert my Column Index Number back to the
respective Column Letter...

TIA

With the column index number in A1:

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


--ron
Reply With QuoteReply With Quote