MID + FIND Function in Excel: Syntax, Examples and Free Practice
MID + FIND is an Excel Text function. Uses FIND twice to locate two delimiters, then MID to extract exactly the text between them.
MID + FIND syntax
Arguments
text: Full text to extract from"-": The delimiter marking each section
When to use MID + FIND
Pulling just the middle segment out of a code like 'REGION-PRODUCT-YEAR'.
Practice MID + FIND online, free
Open the live Excel-style spreadsheet and try MID + FIND yourself. No Excel install or sign-up needed to start.
Practice MID + FIND now →More Text functions
Frequently asked questions
What does the MID + FIND function do in Excel?
Uses FIND twice to locate two delimiters, then MID to extract exactly the text between them.
What is the syntax of MID + FIND in Excel?
The syntax is =MID(text, FIND("-", text)+1, FIND("-", text, FIND("-", text)+1)-FIND("-", text)-1). text: Full text to extract from; "-": The delimiter marking each section.
Where can I practice MID + FIND online for free?
Open the free live spreadsheet on Cellgrids and try MID + FIND yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Text functions · Excel case studies · Excel tutorials · Excel shortcuts