Text concatenation operator

Application: Spreadsheet Desktop version

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

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