Excel: Extract Text Between Characters (Using TEXTBEFORE and TEXTAFTER Functions)

There is no TEXTBETWEEN function in Excel so the next best thing is to combine the new TEXTBEFORE and TEXTAFTER functions in Excel 365 to quickly extract text between two characters.

Whether you're working with emails, URLs, part numbers or other structured text, this video will teach you how to extract just the info you need, no complex formulas required!

What you'll learn:
- How TEXTBEFORE and TEXTAFTER work
- How to extract text between two characters or strings of characters
- How to combine these functions into a single clean formula

🗒 Notes and Resources
Download a copy of the file(s) used in this video: https://share.zight.com/12um6bo4

VIDEO: Extract Text Between Characters in Excel Using Power Query: https://youtu.be/YMAhgiREdGc

The formulas that I used in the demos:
=TEXTAFTER(A1, "//")
=TEXTBEFORE(B1,"/")
=TEXTBEFORE(TEXTAFTER(A1, "//"), "/")

✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk

🙋‍♂️ Let's connect on social
Twitter: https://twitter.com/theexceltrainer
Facebook: https://www.facebook.com/theexceltrainer
LinkedIn: https://www.linkedin.com/in/thomasmik

#ExcelTips #TEXTBEFORE #TEXTAFTER

Видео Excel: Extract Text Between Characters (Using TEXTBEFORE and TEXTAFTER Functions) канала Mike Thomas