DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What is the use of the concatenate function?
|
|
It is used for determining the range
|
|
|
It is used to highlight values
|
|
|
It is used to combine values from two or more cells
|
|
|
It is used to fill in values from smallest to biggest
|
Explanation:
Detailed explanation-1: -You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function.
Detailed explanation-2: -Use CONCATENATE, one of the text functions, to join two or more text strings into one string.
Detailed explanation-3: -You can employ the CONCATENATE function or the & operator to join the cells’ values first, and then merge the cells if needed. In Excel 2016-Excel 365, you can also use the CONCAT function for the same purpose.
Detailed explanation-4: -In C, the strcat() function is used to concatenate two strings.
There is 1 question to complete.