DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following operator can be used instead of concatenate( )?
|
|
$
|
|
|
&
|
|
|
*
|
|
|
None of the above
|
Explanation:
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: -The string operator (&) can be used in formulas to concatenate, or join, two or more strings or the contents of referenced cells. Wildcards (*, ?, ) can be used in conditions to represent one or more characters.
Detailed explanation-3: -Use the + operator The + operator can be used to concatenate two different strings.
There is 1 question to complete.