The text concatenation operator combines data from text cells into one string.

Text concatenation operator

Meaning

Example

&

Connects strings from two or more than two cells to produce one continuous sequence of characters

Cells: А2 (My) and А3 (Office)

Formula: =А2&А3

Result: MyOffice

 

To combine data from 3 or more cells, use a text operator before each new cell address.
Was this helpful?
Yes
No
Previous
Comparison operators
Next
Reference operators