USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
AND
|
|
|
MID
|
|
|
TRIM
|
|
|
CONCATENATE
|
Detailed explanation-1: -Use CONCATENATE, one of the text functions, to join two or more text strings into one string.
Detailed explanation-2: -The string operator (&) can be used in formulas to concatenate, or join, two or more strings or the contents of referenced cells. Wildcards (*, ?, ) can be used in conditions to represent one or more characters.
Detailed explanation-3: -Concatenation operators join multiple strings into a single string. There are two concatenation operators, + and & .
Detailed explanation-4: -strcat() function is the easiest way to concatenate two strings in C language. This function takes two arguments for work. The first one is ‘destination string’ and the second is ‘source string’. The two strings will be concatenated and will be stored in the destination string as a result.