column heading formula
=LEFT(ADDRESS(1,COLUMN(),4,1),IF(COLUMN()<27,1,2))
Regards,
Stefi
€žEricBB€ť ezt Ă*rta:
i'm in column A, i type this formula in a cell , cell("col") then it gives a
result of 1. my problem is what formula should i type to get a result of A
(column heading)? appreciate any help.
EricBB
|