Text concatenation operator

Product:

Application: Table Web version

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

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