CONCATENATE vs LET

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

  CONCATENATE

  • Text

    CONCATENATE belongs to the Text category. Excel functions for manipulating and analyzing text data Click to see all.

  LET

  • Engineering

    LET belongs to the Engineering category. Excel functions designed for engineering calculations and analysis Click to see all.

• Operation Type 🔧

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

  Both*

  • Manipulation

    Functions that modify and transform data in different ways