top of page

&

String Concatenation

& operator is another way to concatenate cells. This method come in very handy in many scenarios because typing the ampersand sign (&) is much quicker than typing the word "concatenate" 

Syntax

Related

CONCAT

TEXTJOIN

CHAR(10)

<value>&<value>[&....]

Note

  • The only essential difference between CONCATENATE and "&" operator is the 255 strings limit of the Excel CONCATENATE function and no such limitations when using the ampersand.

​

  • Other than that, there is no difference between these two concatenation methods, nor is there any speed difference between the CONCATENATE and "&" formulas.

bottom of page