DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
LEFT . function
|
|
RIGHT . function
|
|
MID . function
|
|
LEN . function
|
Detailed explanation-1: -The RIGHT function is a text string function that gives the number of characters from the right side of the string. It helps extract characters beginning from the rightmost side to the left.
Detailed explanation-2: -The RIGHT function in Excel returns the specified number of characters from the end of a text string. Where: Text (required)-the text string from which you want to extract characters. Num chars (optional)-the number of characters to extract, starting from the rightmost character.
Detailed explanation-3: -RIGHT returns the last character or characters in a text string, based on the number of characters you specify. RIGHTB returns the last 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-4: -The RIGHT function in Excel extracts a specific number of characters from a text string, starting from the rightmost character. This function relies on the relative position of characters in a text string.
Detailed explanation-5: -The Right function is the same as in the Worksheet function and VBA. The use of this function is that it gives us the substring from a given string, but one can search from right to left of the string. This type of string function in VBA one may use with application.