The MID function returns a string value consisting of the given number of characters from a string value starting at the specified position.
MID(source-string, start-pos, string-length)
source-string: Any value.
start-pos: A number value specifying the position within the specified string at which the action should begin. start-pos must be greater than or equal to 1 and less than or equal to the number of characters in source-string.
string-length: A number value specifying the desired length of the returned string. string-length must be greater than or equal to 1.
Notes
If string-length is greater than or equal to the length of source-string, the string returned is equal to source-string, beginning at start-pos.
Examples |
|---|
=MID(“lorem ipsum dolor sit amet”, 7, 5) returns “ipsum”. =MID(“1234567890”, 4, 3) returns “456”. =MID(“shorten”, 5, 20) returns “ten”. |