DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Left
|
|
|
Right
|
|
|
Mid
|
|
|
Value
|
Detailed explanation-1: -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-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: -The LEFT function in Excel is a type of text function in Excel that gives the number of characters from the start of the string, from left to right. So, for example, if we use this function as =LEFT ( “ANAND”, 2) this will give us AN as a result.
Detailed explanation-4: -The VLOOKUP or Vertical Lookup function is used when data is listed in columns. This function searches for a value in the left-most column and matches it with data in a specified column in the same row. You can use VLOOKUP to find data in a sorted or unsorted table.