28 - Transform Text with Extract Options in Power Query
In this video, I will show you how to extract the text data in Power Query editor. You can easily perform tasks such as extract some text based on the length or a delimiter
✅ Power Query Course Download files: https://trumpexcel.com/course-downloa...
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB
Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
Best Excel Books: https://trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...
------------------------------------------------------------------------------
0:00 - Introduction to Power Query Extract Options
0:23 - Exploring the Extract Options in Transform Tab
0:54 - Using the Length Option for Characters Count
1:25 - Extracting First Characters from Text
2:00 - Using Last Characters Option
2:26 - Working with Range Extraction
3:01 - Text Before Delimiter Option
4:02 - Text After Delimiter Option
4:36 - Text Between Delimiters Option
5:35 - Final Tips for Working with Text Data
------------------------------------------------------------------------------
#Excel #PowerQuery #ExcelTips