Column()

[Phyliss]

Hi
Column() returns the numeric index of the column. Is there anyway to reurn
the letter of the column?
Thanks
Phyllis

 

[Paul Corrado]

=CHAR(COLUMN()+64)

Will work for A-Z

=ADDRESS(1,COLUMN(),4) anywhere in Column A will return A1

 

[JE McGimpsey]

One way:

=LEFT(ADDRESS(1,COLUMN(),2),1+(COLUMN()>26))

 

[Paul B]

Phyliss, try this, =CHAR(64+COLUMN())
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **

 

[Harald Staff]

Hi Phyllis

=LEFT(ADDRESS(1,COLUMN(),4),1+(COLUMN()>26))

HTH. Best wishes Harald

 

[Arvi Laanemets]

Hi

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


Arvi Laanemets