More examples of using the MID function in Excel:
- Extract text between two characters - how to find and extract text from string between two characters or words in Excel and Google Sheets.
- How to remove only leading spaces - how to remove only spaces before words, leaving multiple in-between spaces intact.
- Extract N characters following a certain character - how to extract a substring of a given length after the specified occurrence of the delimiter/character.
- Extract text between parentheses - self explanatory :)
- How to extract domain names from URLs - a very clever formula to extract domain names with or without www. and with any protocol (http, https, ftp etc.).