Скачать или смотреть Extract Text Between Characters in Excel Using Power Query

Have you ever needed to extract text from between a set of parentheses in Excel? Or extract a URL from between a pair of hash tags? Or do anything similar?

If you have you'll know just how long it can take to work out the logic in your head, type the formula (MID, FIND, LEFT, RIGHT and more) and check for typos. Thanks to the magic of Power Query you can do it in a couple of minutes at most!

The video covers 4 different scenarios including starting from the end of the string, starting with the Nth (2nd, 3rd etc) occurrence and extracting from between multi-character strings.

For full details see the timestamps below:

⏱ Timestamps
00:00 Introduction
01:10 Simple example - extract all text between two characters (brackets in this case)
03:17 Extract text between the last occurrence of a character and the first occurrence of a different character
05:20 Extract text between the second and third occurrences of a character
07:41 Extract text between a string and a single character

🗒 Notes and Resources
Download a copy of the file used in this video: https://share.getcloudapp.com/z8uLmYqE

✅ 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:   / theexceltrainer  
Facebook:   / theexceltrainer  
LinkedIn:   / thomasmik  

#excel #powerquery #extracttext