FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Use the ampersand & character instead of the CONCATENATE function. 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).

Detailed explanation-2: -Concatenation is the process of appending one string to the end of another string. You concatenate strings by using the + operator. For string literals and string constants, concatenation occurs at compile time; no run-time concatenation occurs. For string variables, concatenation occurs only at run time.

Detailed explanation-3: -Use the ampersand (&) to concatenate (join) one or more text strings to produce a single piece of text. Text operator. Meaning.

Detailed explanation-4: -Answer: The concatenate operator is also known as the concatenate operator. It is used to combine one or more text strings to produce an output as a single string.