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
|
|
|
len
|
Detailed explanation-1: -MID returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify.
Detailed explanation-2: -Summary. The Excel MID function extracts a given number of characters from the middle of a supplied text string. For example, =MID("apple", 2, 3) returns “ppl".
Detailed explanation-3: -=MID(text, start num, num chars) The MID function uses the following arguments: Text (required argument) – The original text string. Start num (required argument) – This is an integer that specifies the position of the first character that you want to be returned.
Detailed explanation-4: -Use the MID and FIND Functions to Extract Text The MID and FIND functions are used to extract text from a cell starting from a specified delimiter.
Detailed explanation-5: -The MID() function extracts a substring from a string (starting at any position). Note: The MID() and SUBSTR() functions equals the SUBSTRING() function.