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

[@yannicktrapman-obrien1217]

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

[@sumitlehri5704]

thanks for this

[@pankajchhawani5948]

This was really helpful. thanks for sharing..

[@sarahmirailh88]

You save me almost everyday. hahaha Thanks!

[@First.Last.99]

helped me, thank you

[@Thekeycuts]

You're welcome!

[@umermalikk9133]

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”)),””)

[@abrahamhahijary]

thanks, very helpful

[@ekaterinafeldman5394]

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

[@Thekeycuts]

You would have to use another character from the cell "find" in order for the formula to work.

[@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 😅

[@Thekeycuts]

Here is a formula that helps you extract middle names into a column when you don't know the number of spaces in the name: www.linkedin.com/pulse/episode-75-how-extract-first-last-multiple-middle-names-al-chen/

[@evertthebassist]

@@Thekeycuts aahhh dude legend!! Thanks so much for the help, i really appreciate it!!!

[@LinhHLe]

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

[@thangaveluraj5366]

Unbearably confusing

[@rj_lab]

Sorry 👎 but thank thanks.