FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Assembles two or more text strings into one
A
CONCATENATE
B
REPLACE
C
PROPER
D
None of the above
Explanation: 

Detailed explanation-1: -Concatenation is the process of appending one string to the end of another string. You concatenate strings by using the + operator. For string literals and string constants, concatenation occurs at compile time; no run-time concatenation occurs.

Detailed explanation-2: -Combine data using the CONCAT function 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-3: -Concatenation operators join multiple strings into a single string. There are two concatenation operators, + and & . Both carry out the basic concatenation operation, as the following example shows.

Detailed explanation-4: -join() There is another, more powerful, way to join strings together. You can go from a list to a string in Python with the join() method.

There is 1 question to complete.