Concatenation (&) text operator in Excel

Excel concatenation (&) text operator is used to concatenate text strings (used to join texts). Text strings to combine can be either enclosed inside double quotes (") or can be text values stored inside Cells.

Text Operator Description
& Concatenate text operator (used to combine texts)

Excel concatenate text operator (&)

Excel Concatenate operator (&) is used to join texts together in Excel formulas. Text strings can be either enclosed inside double quotes (") or can be values stored in Cells, or output of Excel functions. Following example shows how to use Excel Concatenate operator (&) to concatenate three texts.

Concatenate Operator usage Description Result
="MS"&" "&"Excel" Concatenates (joins) three text together. Three texts are "MS", " " (single space) and "Excel". MS Excel

Related Tutorials
Cell reference (Cell address)
Range reference
What are Excel formulas
How to write formulas in Excel
How to see all formulas in Excel sheet
Mathematical operators in Excel
Comparison operators in Excel
Concatenate (&) text operator in Excel
Cell or range reference operators in Excel
Union and Intersection of Excel ranges
Operator Precedence in Excel
How to change the operator precedence in Excel
Error messages in Excel Formulas
Hash error in Excel (#### in excel)
Multiple parenthesis in Excel formulas
Trace error in Excel formulas
How to remove trace error arrows in Excel
Relative and absolute reference in Excel
F4 key in Excel formula
Mixed Cell reference in Excel