DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
arithmetic
|
|
comparison
|
|
text concatenation
|
|
reference
|
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.