View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
masterbaker masterbaker is offline
external usenet poster
 
Posts: 19
Default Column Name Formula

This should be an easy one:

Is there a function that returns the name of the column (A,B,C,....) just
like there is one for row, but returns the static value of the column (A,B,C)
and not just a column number??

I can do it by setting up a table and associating 1 with A, 2 with B, and so
on...but that's anoying especially if I am expecting to go past the 26 letter
alphabet into the combinations.

Thanks for any help!!!