Description
Returns a specified number of characters from a text value, starting at a given position.
NOTES
- The first character in the text has position
1. - If start_num is greater than the length of the text, the function returns an empty text (
""). - If num_chars is
0, the function returns an empty text (""). - If num_chars is negative, the function returns an error.
Syntax
Copied!=MID(text, start_num, num_chars)
SAMPLE-1
EXAMPLE 1.1
Copied!=MID(A2:A6, 5, 8)