★0 XP
Question 1 of 10
The MID function in Excel returns text from the middle of another string of text, the way LEFT and RIGHT return the left-most and right-most characters from a string of text.
The first argument is the original string of text, the second argument is the number of the character at which you want to start extracting text, and the third argument is the number of characters you want to extract.
For example, =MID("Hello", 2, 3) returns three characters from the string "Hello" starting at character #2. What would the formula return?
The first argument is the original string of text, the second argument is the number of the character at which you want to start extracting text, and the third argument is the number of characters you want to extract.
For example, =MID("Hello", 2, 3) returns three characters from the string "Hello" starting at character #2. What would the formula return?
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ||||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 |
fx