Which operator is used for joining the text together?give an example.�

1.	Which operator is used for joining the text together?give an example.
Answer» The AMPERSAND (&) CALCULATION operator lets you join text items without having to use a FUNCTION. For example, =A1 & B1 returns the same value as =CONCATENATE(A1,B1). In many cases, using the ampersand operator is quicker and simpler than using CONCATENATE to CREATE strings.

Discussion