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 the material useful?
Yes
No