Extract Text Between Two Characters - Brackets or Commas etc

In this video I demonstrate how to extract text between two brackets, commas or any other character.
------------------------

[Mikej]

I love the method used to explain it by breaking down each step, super easy to understand that way. Thank you

[mattsimon]

the best video I found at breaking apart each function so I could understand it...thank you so much

[joycenascimento]

Great way of explaining the long formula, separating it in 3 and putting it together. Thank you!

[philzills]

Thank you for this video. It helped me through a project

[tiastarr_]

I have been trying to figured out how to pull the account number only from the chart of accounts number string for 2 days and this did it in 2 minutes!!!! Thank You so much for your help!!!!

[ubaidillahmuhammad]

loved it, sir. please make about combination formula excel

[IvanCortinas_ES]

Excellent tutorial. A great formula built little by little. Thank you Chester!

[manjiniarul]

wow. This is a great video and solved my current requirement. Big thanks!

[rogenfrancerogenttolentino]

Hi @Chester thank you for this! You are a legend!

[shoaibrehman]

Amazing 👏, all methods are gr8 will depend on which situation

[Harmony_Worship]

Great tutorial, I was able to get the same results following along. But I'm struggling at translating into words part I don't understand why we put the mid function twice at the left formula.

[LotfyKozman]

Thanks a lot, it's really very helpful.

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