Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • IF with AND and IF with OR AND
  • Dynamic selection list ActiveX controls
  • Comments versus Notes Excel User tips
  • Change Calculator – calculate change in multiple bills/coins Formulas - combined functions
  • Fx to cut long column into two columns Formulas - combined functions
  • Expenses calendar, FaCal Basic Math
  • Unix DateTime Number Basic Math
  • Min Max vehicle Formulas - combined functions

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

Posted on April 6, 2015 By ANmar

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

4-6-2015 9-25-15 AM

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()

4-6-2015 9-27-34 AM

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

4-6-2015 9-32-57 AM

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)

4-6-2015 9-35-42 AM

 


 

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

2012-02-19-031500

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

ADDRESS, CHAR, COLUMN, Formulas - combined functions, LEFT, Lookup and References, ROW, SEARCH, Standard functions, Texts and Strings Tags:Column, Columnname, name

Post navigation

Previous Post: Week number to Sunday date – Weeknum reverse
Next Post: Why I ran from =INDIRECT() function

Related Posts

  • Multiple-Validations (connected to each other) Data Validation
  • Progress bar in pure functions CHAR
  • Multiple lines in cell using functions CHAR
  • iframe in Excel (XLiFrame) ADDRESS
  • Validation based on another Validation COUNTA
  • Always get 1st name (or last) Formulas - combined functions

Recent Posts

  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage
  • Jan8 date format

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (82)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (30)
      • AND (5)
      • IF (24)
      • IFERROR (6)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (5)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • Repeated Offset Basic Math
  • Hello world! Uncategorized
  • Excel Dynamic Drop-Downs that grow with you COUNTA
  • Expenses calendar, FaCal Basic Math
  • Recover the unrecoverable Excel User tips
  • Links between two workbooks – dynamically using functions INDIRECT
  • Cell formats 0.0\% and 0.0%;(0.0%) Format Cells
  • Edit directly in cell Excel User tips

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme