MID
Description
Returns the middle characters from a string, based on the specified text and number of characters.
Syntax
MID(
text
,
start_num
,
num_chars
)
- text: The text to return characters from.
- start_num: The position of the first character to return.
- num_chars: The number of characters to return.
Example
Formula | Result |
|---|---|
=MID(A1,10,5)
Where cell A1 contains
Regional Sales Manager
.
| Sales |