Thread: inverse of the column function? i.e. input a number, output thecorresponding column text label
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lars-Åke Aspelin[_2_] Lars-Åke Aspelin[_2_] is offline
external usenet poster
  
Posts: 913
Default inverse of the column function? i.e. input a number, output the corresponding column text label
On Fri, 13 Feb 2009 12:54:29 -0500, "Rick Rothstein"
wrote:

Here is yet another way...

=IF(A126,CHAR(64+INT(A1/26)),"")&CHAR(65+MOD(A1-1,26))

For A1=52 this gives BZ instead of AZ
For A1=78 this gives CZ instead of BZ
and so on

And if you have Excel 2007, the formula does not work for A1702

Lars-Åke
Reply With QuoteReply With Quote