USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
concatenate
|
|
|
proper
|
|
|
left
|
|
|
e=mc2
|
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 ampersand (&) calculation operator lets you join text items without having to use a function. For example, =A1 & B1 returns the same value as =CONCATENATE(A1, B1). In many cases, using the ampersand operator is quicker and simpler than using CONCATENATE to create strings.
Detailed explanation-3: -The word CONCATENATE means to join or combine. The CONCATENATE function in Excel is used to combine the text from different cells into one cell.
Detailed explanation-4: -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], …)