Text Manipulationintermediate
Extract a substring from the middle with MID
=MID(A2,5,3)
Worked examples (1)
These formulas work in Google Sheets with identical syntax.
Also in Excel
See the full MID reference for Excel — including all worked examples, common errors, and FAQ.
MID Excel reference →