FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
To combine two or more text strings into one text string is a function of:
A
LEFT
B
RIGHT
C
CONCATENATE
D
LEN
E
SUBSTITUTE
Explanation: 

Detailed explanation-1: -The CONCATENATE function joins two or more text strings together into one string. For example, if you have the customer’s first name in Column A and the last name in Column B, you could use “=CONCATENATE(A3, “ ”, B3)” to produce a string containing first name and last name.

Detailed explanation-2: -Use CONCATENATE, one of the text functions, to join two or more text strings into one string.

Detailed explanation-3: -strcat()-Concatenate Strings The strcat() function concatenates string2 to string1 and ends the resulting string with the null character. The strcat() function operates on null-ended strings. The string arguments to the function should contain a null character () that marks the end of the string.

Detailed explanation-4: -The CONCATENATE function in Excel is used to join different pieces of text together or combine values from several cells into one cell. The syntax of Excel CONCATENATE is as follows: CONCATENATE(text1, [text2], …) Where text is a text string, cell reference or formula-driven value.

There is 1 question to complete.
Previous
Next