Return Column sign - PLEASE HELP
 

Hi
I need a formula that returns the coulmn sign e.g. "A", "AB"

thanks

Return Column sign - PLEASE HELP
 

Hi

From a recent posting by Luc (PapaDos)

=SUBSTITUTE( ADDRESS( 1, COLUMN( A1 ), 4 ), "1", "" )
Copy across sheet as necessary

--
Regards

Roger Govier


"Nir" wrote in message
...
Hi
I need a formula that returns the coulmn sign e.g. "A", "AB"

thanks