Question

write one example for the syntax for joining multiple text string into one

Answer 1

Explanation:

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

Answer 2

Answer:

Pls mark me as brilliant.

Explanation:

There are two ways to do this:

1) Add double quotation marks with a space between them " ". For example:     =CONCATENATE("Hello", " ", "World!").

2) Add a space after the Text argument. For example: =CONCATENATE("Hello ", "World!"). The string "Hello " has an extra space added.