USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
To combine text that is in two different cells, use the formula:
|
|
COMBINE
|
|
|
MATCH
|
|
|
CONCATENATE
|
|
|
SUBTOTAL
|
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 CONCAT function in Excel is used to combine strings from multiple cells or ranges into a single cell. It is categorized under Text functions and is available in Excel for Microsoft 365, Excel 2021, Excel 2019, and Excel for the web. The syntax is as simple as this: CONCAT(text1, [text2], …)
There is 1 question to complete.