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.

Question regarding : CHAR(64+COLUMN())
 

Maybe...
=SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1","")

Andrew wrote:

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.

--

Dave Peterson

Question regarding : CHAR(64+COLUMN())
 

One way to return the required "AA" to "IV" for copying across:
=CHAR(INT((COLUMN(A1)-1)/26)+65)&CHAR(MOD(COLUMN(A1)-1,26)+65)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Andrew" wrote in message
...
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.