VISUAL PROGRAMMING
VISUAL BASIC
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Trim
|
|
Mid
|
|
Instr
|
|
None of the above
|
Detailed explanation-1: -Generally speaking, the MID function in Excel is designed to pull a substring from the middle of the original text string. Technically speaking, the MID function returns the specified number of characters starting at the position you specify. Where: Text is the original text string.
Detailed explanation-2: -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) Text is the text string containing the characters you want to extract. Start num is the position of the first character you want to extract in text. Num chars specifies the number of characters you want MID to return from text.