Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Extract Text Between Spaces? Formulas? LET Function? Power Query? 5 Examples! EMT 1736.

Posted on by Bb

Download Excel File: https://excelisfun.net/files/EMT1736.xlsx
Learn how to extract an ID number between a start and end space delimiter.
Topics:
1. (00:00) Introduction
2. (00:32) Worksheet Formula with 6 functions.
3. (02:21) LET function to remove formula elements that are repeated.
4. (03:50) Worksheet Formula with 5 functions.
5. (04:47) INDEX and FILTERXML function example.
6. (05:17) Power Query Extract Between Delimiters.
7. (05:58) Summary, Closing and Video Links

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.

ExcelIsFunMon, August 9, 2021 9:10pm