View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Frederik[_3_] Frederik[_3_] is offline
external usenet poster
 
Posts: 63
Default column heading formula

here we go:

=CHAR(COLUMN()+64)

greetings

"EricBB" schreef in bericht
...
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