DATABASE FUNDAMENTALS
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 combines the text from multiple ranges and/or strings, but it doesn’t provide delimiter or IgnoreEmpty arguments. CONCAT replaces the CONCATENATE function. However, the CONCATENATE function will stay available for compatibility with earlier versions of Excel.