In this video. I will take you through some common and useful text functions in Power Query.
✅ Power Query Course Download files: https://trumpexcel.com/course-download-files/
☕ 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/trumpexcel?sub_confirmation=1
------------------------------------------------------------------------------
0:00 - Introduction
0:22 - Overview of Extract Text Options
1:02 - Understanding the Formula Bar
2:59 - Creating Custom Text Columns
4:15 - Using Text.Length Function
4:55 - LEFT Function Equivalent (Text.Start)
6:11 - Finding Text Position (Text.PositionOf)
8:54 - Handling Not Found Text Values
------------------------------------------------------------------------------
#Excel #PowerQuery #ExcelTips
