DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Extracts one or more characters from the left side of a textstring
|
|
LEFT
|
|
|
RIGHT
|
|
|
MID
|
|
|
CONCATENATE
|
Explanation:
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: -Excel LEFT function-syntax The LEFT function in Excel returns the specified number of characters (substring) from the start of a string.
Detailed explanation-3: -To extract a substring of a certain length from anywhere in the middle of a string, use the MID function. Here in this example, I enter =MID(A2, 6, 4) to extract four characters starting from the 6th character of the product code.
There is 1 question to complete.