View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Translate Column Index Num to Letter

Another one:

=SUBSTITUTE(ADDRESS(1,col_index_num,4),1,"")

Biff

"T. Valko" wrote in message
...
=LEFT(ADDRESS(1,col_index_num,4),LEN(ADDRESS(1,col _index_num,4))-1)

Biff

"DJS" wrote in message
...
Looking for a quick and easy way to revert my Column Index Number back to
the
respective Column Letter...

TIA