USING MICROSOFT EXCEL
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.
Detailed explanation-3: -Merge cells Select the cells that you want to merge. Under Table Tools, on the Layout tab, in the Merge group, click Merge Cells.
There is 1 question to complete.