FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The function that takes the characters from the left is named:
A
LEFT . function
B
RIGHT . function
C
MID . function
D
LEN . function
Explanation: 

Detailed explanation-1: -Summary. The Excel LEFT function extracts a given number of characters from the left side of a supplied text string. For example, LEFT("apple", 3) returns “app".

Detailed explanation-2: -LEFT returns the first character or characters in a text string, based on the number of characters you specify. LEFTB returns the first character or characters in a text string, based on the number of bytes you specify. Important: These functions may not be available in all languages.

Detailed explanation-3: -The LEFT function returns the specified number of characters from the start, or the left, of a text string. The syntax for the LEFT function looks like this: =LEFT(text, [num chars]). Click in the cell where you want to insert the function.

Detailed explanation-4: -Extract text string using the LEFT function The LEFT function extracts a given number of characters starting from the left side of a string. 1. Type “=LEFT(” in cell C2 where you want the first Area Code.

Detailed explanation-5: -The LEFT() function extracts a number of characters from a string (starting from left).

There is 1 question to complete.
Previous
Next