Get column name (columnname as A,B,C, etc) as input inside cell

Excel already has the formula ROW()
=Row()
Which as we may already know will give us the number of the row we are in, if you add no parameters

However, the COLUMN() is kind of tricky

Because of the fact that cell addresses (or references) are based on the old style of R1C1

=Column()

What usually human wants is the letter of the column (column name or column header, whatever you call it), so it should brings E instead of 5 in example above. But COLUMN() does not do that for you.

Yes, we can always convert the column into ASCII char code, like this maybe

=CHAR(Column()+64)

But this will stop after column Z

So I find in my experience, the best way to get that column header, is….

What???

Combination of more than 3 functions, Duh!!

=LEFT(ADDRESS(ROW(),COLUMN(),2),SEARCH("$",ADDRESS(ROW(),COLUMN(),2))-1)

If you already seen my iframe in Excel, you may already recognized this set of formulas there, I used it to mimic creating headers in that sheet

Thought this set, deserves to get a post on its own