Skip to main content

Text concatenation operator

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

Text concatenation operatorMeaningExample
&Connects strings from two or more than two cells to produce one continuous sequence of charactersCells: А2 (My) and А3 (Office) Formula: =А2&А3 Result: MyOffice
warning

To combine data from 3 or more cells, use a text operator before each new cell address.