LEN vs YEAR vs LOWER

Basic Classification Comparison

• Function Category 📊

  Primary classification of the Excel function based on its main purpose and usage domain, helps users quickly identify function types

  LEN

  • Text

    LEN belongs to the Text category. Excel functions for manipulating and analyzing text data

  YEAR

  • Date & Time

    YEAR belongs to the Date & Time category. Excel functions for working with dates and time calculations  Click to see all.

  LOWER

  • Text

    LOWER belongs to the Text category. Excel functions for manipulating and analyzing text data

• Operation Type 🔧

  Fundamental type of operation or action that the Excel function performs on its inputs

  LEN

  • Manipulation

    LEN performs Manipulation operations. Functions that modify and transform data in different ways

  YEAR

  • Information

    YEAR performs Information operations. Functions that focus on retrieving and displaying data in various formats

  LOWER

  • Manipulation

    LOWER performs Manipulation operations. Functions that modify and transform data in different ways