Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Links between two workbooks – dynamically using functions INDIRECT
  • UDF – Convert Number into text (English and Arabic) User-Defined f(x)s = UDF
  • When Excel functions are not enough Excel User tips
  • Custom fiscal year calendar (CFlex) Basic Math
  • Why I ran from =INDIRECT() function Formulas - combined functions
  • IFS (and IFNA) to avoid nested IFs Formulas - combined functions
  • FORMULATEXT to show formulas FORMULATEXT
  • MID + SEARCH to convert cell to rows MID

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

  • CHOOSE – tree of decisions CHOOSE
  • Highlight dates dynamically AND
  • Min Max vehicle Formulas - combined functions
  • Unix DateTime Number Basic Math
  • CONVERT function CONVERT
  • Week number to Sunday date – Weeknum reverse DATE

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
  • Expenses calendar, FaCal Basic Math
  • Tally chart in functions Formulas - combined functions
  • Why I ran from =INDIRECT() function Formulas - combined functions
  • Worksheet name, dynamically using formula CELL
  • UDF – Convert Number into text (English and Arabic) User-Defined f(x)s = UDF
  • Dynamic selection list ActiveX controls
  • Custom fiscal year calendar (CFlex) Basic Math
  • Cell formats 0.0\% and 0.0%;(0.0%) Format Cells

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme