It doesn't update very well, but...

=CHAR(CELL("col")+64)

"Fred" wrote:

Hello,
Does anyone know how to extract only the Column Name of an active cell in
another cell. e.g. If active cell is D4 then I want the "D" to be extract and
displayed in another cell say A1. Let me know.

Regards,
Fred