28 - Transform Text with Extract Options in Power Query
Вставка
- Опубліковано 9 січ 2025
- 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: trumpexcel.com...
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoff...
Free Excel Course (Basic to Advanced) - trumpexcel.com...
Best Excel Books: trumpexcel.com...
Subscribe to get awesome Excel Tips every week: www.youtube.co...
#Excel #PowerQuery #ExcelTips
Thanks for the lesson.
Good Session
Hi is there a version issue that you are not getting the text icon where you are adding the delimiter
U are the best
Hi, Thanks for your videos I find them really instructive for learning Excel. I have a question, is it possible to extract a word from each cell based on the value of another cell? Let's suppose I have list A, which has just one word, lets suppose car, then I also have another list (list B) which contains just sentences, lets say one cell has the sentence "the car is red". Is possible to show which cells form list B have a matching word from list A?
use search or find to solve your issue
Great video. How we can install power query.
check the 2nd video of this series
👍
do have whatup group or telegram