FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The function used to retrieve the left side of the text data as many characters as specified ____
A
Left
B
Right
C
Mid
D
Value
Explanation: 

Detailed explanation-1: -Description. 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.

Detailed explanation-2: -The LEFT Function[1] is categorized under Excel TEXT functions. The function will return a specified number of characters from the start of a given text string. In financial analysis, the LEFT function can be useful if we wish to extract characters from the left side of a text.

Detailed explanation-3: -Excel LEFT function-syntax The LEFT function in Excel returns the specified number of characters (substring) from the start of a string.

Detailed explanation-4: -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".

There is 1 question to complete.
Previous
Next