AMPERSAND Operator (&) - Excel
Overview
The Ampersand operator (&) in Excel is a useful tool for text concatenation. This operator allows users to join or concatenate different pieces of text into a single text string.
Syntax:
=text1 & text2
text1 and text2 can be text strings, cell references, or a combination of both.
Example: cell reference
In this example, the Ampersand operator is concatenating two strings. Cell C2 equals "hiking” and cell D2 equals "trail” so the Ampersand operator will combine those two strings for a final output of “hikingtrail”.
Example:
=C2 & D2
Example: hardcoded
In this example, the Ampersand operator is concatenating three strings with one of them being a hardcoded space between the two reference cells. Cell C2 equals "hiking”, cell D2 equals "trail” and we’ve hardcoded a space (“ “) between them so the final output will be “hiking trail”.
Example:
=C2 & " " & D2