=LEFT(ADDRESS(ROW(),COLUMN(),4),LEN(ADDRESS(ROW(), COLUMN(),4))-
LEN(ROW()))

hth

Carlo

On Nov 15, 4:26 pm, EricBB wrote:
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