MID
Returns a specific number of characters from a text string starting at the position you specify
Syntax
MID(text, start_num, num_chars)
Parameters
- text: Required. The text string containing the characters you want to extract
- start_num: Required. The position of the first character you want to extract in text (1-based)
- num_chars: Required. The number of characters you want MID to return from text
Example
=MID("Fluid Flow", 1, 5)