How to extract text from a middle of a cell in Google Sheets or Excel using MID and FIND functions

Sometimes you have a long list of data in a column and you want to pull out a specific string of characters in the cell and put the output in another column. This episode dives into the nested formula using MID() and FIND() to pull out just the data you need from a cell that contains a lot of data.

* Intro - 0:00
* The MID() function - 0:13
* The FIND() function - 2:00
* Using Text-to-Columns - 11:27

[yannicktrapman-obrien]

Very good tutorial - I really appreciate how you went step by step so I could see why each iteration was not yet successful.

[pankajchhawani]

This was really helpful. thanks for sharing..

[umermalikk]

HI, i need to extract text between two words and i am using below formula but its not working can you help ? i am trying to find all the words between KTE AND FUT, IFERROR(MID(A9, SEARCH(“KTE”, A9)+LEN(“KTE”), SEARCH(“FUT”, A9)-SEARCH(“KTE”, A9)-LEN(“KTE”)), ””)

[sarahmirailh]

You save me almost everyday. hahaha Thanks!

[LinhHLe]

why dont use regulareplace with [*[:alpha:]]?

[ekaterinafeldman]

This is great! But what if there are no parenthesis?

[evertthebassist]

This cool. But what if you don't have parentheses to work with. What if i want to extract between the first space and the last space? So i have to extract first and middle name (some times more than one middle name, which means not a constant numer of spaces throughout the column) between the salutation and the surname. If anyone can tell me that, that will save me hours - hours and hours of work 😅