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 |