DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
the CONCATENATE function is used for?
|
|
combines the contents of two or more cells
|
|
|
count the number of cells that have a value
|
|
|
count the number of cells that have a text value
|
|
|
counts the number of cells that have numeric values / numbers
|
Explanation:
Detailed explanation-1: -Type =CONCAT(. Select the cell you want to combine first. Use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text. Close the formula with a parenthesis and press Enter.
Detailed explanation-2: -The CONCATENATE function allows you to combine text from different cells into one cell. In our example, we can use it to combine the text in column A and column B to create a combined name in a new column.
There is 1 question to complete.