CONCATENATE vs EXACT 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

  For all*

  • Text

    Excel functions for manipulating and analyzing text data

• Operation Type 🔧

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

  CONCATENATE

  • Manipulation

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

  EXACT

  • Comparison

    EXACT performs Comparison operations. Excel functions for comparing values and data  Click to see all.

  LOWER

  • Manipulation

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