View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andrew
 
Posts: n/a
Default Question regarding : CHAR(64+COLUMN())

I have indirect formulaue in various cells that refer to certain columns in a
very large spreadsheet using the above formulae . The formulae above is
pasted along row 1 and allows me to insert colums, drag and drop data etc but
still feed data into the solution. My problem is that after I reach column Z
the above formulae defaults to symbols and then to lower case letters again.
This does not work with my indirect formulae collecting info from columns
after row Z. How can I change the above formulae to continue with letters (?)
after Z ? Any assistance appreciated.