USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The CONCATENATE function breaks a text string into separate strings
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -The CONCATENATE function breaks a text string into separate strings. A delimiter is a data separator. Data can be consolidated from different workbooks in one worksheet.
Detailed explanation-2: -Use CONCATENATE, one of the text functions, to join two or more text strings into one string.
Detailed explanation-3: -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.
There is 1 question to complete.