CONCAT Function

🎯Purpose

Combines the text from multiple ranges and/or strings, but it does not provide delimiter or IgnoreEmpty arguments. It is the modern replacement for CONCATENATE.

Syntax

EXCEL

=CONCAT(text1, [text2], ...)

Arguments Breakdown

Argument	Required?	Description
`text1`	Required	Text item, cell reference, or range to be joined.
`text2, ...`	Optional	Additional text items or ranges to be joined (up to 254 arguments).

Practical Examples

1. Combining City & Country Drill

From Formulas_&_Functions_Part_1.xlsx:

EXCEL

=CONCAT(C1, D1)

Where C1 is "Cai" and D1 is "ro " $\rightarrow$ "Cairo ".

2. Full Name Assembly with Space

EXCEL

=CONCAT(Employees[First Name], " ", Employees[Last Name])

CONCAT vs CONCATENATE vs TEXTJOIN

CONCATENATE: Legacy function, cannot accept full ranges like A1:A5 (must specify each cell individually).
CONCAT: Modern function, accepts 2D ranges =CONCAT(A1:C1).
TEXTJOIN: Preferred when you need a delimiter (like a comma, slash, or space) or need to ignore empty cells.

Related Knowledge

Notes: 05 Text Manipulation Functions
Workbook: 11_Demos_and_Workbooks/03_Formulas_and_Functions/Formulas_&_Functions_Part_1.xlsx (Sheet: Text)