Compact mode

RIGHT vs CONCATENATE vs LEFT

Basic Classification Comparison

Basic Information Comparison

  • Known For

    Distinctive characteristic or primary strength of the Excel function
    RIGHT
    • Extract Rightmost Characters
      RIGHT is known for Extract Rightmost Characters.
    CONCATENATE
    • Text Joining
      CONCATENATE is known for Text Joining.
    LEFT
    • Text Extraction
      LEFT is known for Text Extraction.

Facts Comparison

  • Interesting Fact 💡

    Unique or lesser-known information about the Excel function
    RIGHT
    • Was created before LEFT function despite being less commonly used
    CONCATENATE
    • Predecessor to &
    LEFT
    • Often paired with RIGHT
  • Sarcastic Fact 🤣

    Humorous or ironic observation about the Excel function
    RIGHT
    • The rebellious twin of the LEFT function
    CONCATENATE
    • Making text joining unnecessarily formal
    LEFT
    • The function that discriminates against right-handed people

Usage Information Comparison

Technical Details Comparison

Ratings Comparison