The MID function returns a sub-string from a string, starting from a specified location. In this guide, we’re going to show you how to use the Excel MID function and also go over some tips and error handling methods.
- All Excel versions
Excel MID Function Syntax
|text||The text that contains the sub-string you want to extract.|
|start_num||The position of the first character of the sub-string you want to extract.|
|num_chars||The number of characters you want to extract.|
- Excel MID function will not extract number formatting characters like currency symbols or thousand separators.
- Try the LEFT function to return a sub-string from right.
- Try the RIGHT function return a sub-string from middle of a string.
- You can use the SEARCH and FIND functions to locate the positions of characters.