How to Split and Transform Text in Excel (Unbelievable Power Query Tricks)
Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Elevate your Excel skills with this informative tutorial, perfect for anyone looking to handle complex text transformations effortlessly. Discover the power of Power Query (Get & Transform) in Excel, a tool that simplifies what would otherwise be complicated tasks using formulas.
⬇️ Download the Workbook: pages.xelplus.com/transform-t...
Here's a glimpse of what you'll learn:
Overview of Text Transformation Challenges: Understand common problems like separating words by delimiters, splitting columns based on logic, and extracting specific text parts, such as numbers from strings.
Power Query vs. Excel Formulas: Learn why Power Query often becomes a more efficient choice over traditional Excel formulas, especially for complex tasks.
Step-by-Step Demonstrations: Follow practical examples that include splitting department and position data into separate columns, extracting employee numbers with specific formats, and dividing full names into first and last names with proper capitalization.
Using Power Query Functions: Get familiar with Power Query features like 'Split Column', 'Extract', and 'Add Prefix', which make text transformations a breeze.
Dynamic Data Updating: See how Power Query allows for easy updates to your data transformations, saving time and effort in managing ongoing data changes.
Final Data Refresh Demonstration: Watch a live demonstration of adding new data to the table and refreshing the query to apply all transformations seamlessly.
Discover the EASIEST way to perform text transformations in Excel. Power Query is the perfect tool for you to solve these tasks that can be quite complicated with just Excel formulas.
Usually, solving these transformations in Excel are NOT an easy task. If you want to do any of the following with Excel formulas, things can get scary very fast:
- Separate words in Excel by a delimiter
- Split a column in Excel based on a certain logic in multiple columns
- Separate text from numbers in a cell
- Extract numbers from the middle of a text string
- Extract text after a specific character in Excel
In this tutorial I'll show you how you can use Power Query to perform some common text transformation tasks. See for yourself how easy these tasks become with some basic Power Query understanding.
Power Query Playlist: • Excel Power Query (Get...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel
Пікірлер: 308
Grab the file I used in the video from here 👉 pages.xelplus.com/transform-text-file
@elyorkeldiyorov3641
3 жыл бұрын
HI, I was just wondering Why I am not havin several options in my SPLIT COLOUMN function in Power Query. I use Office 2019 Thank you beforehand :)
A wonderful explanation. Power Query is highly productive. Thank you for sharing Leila!
You make the difficult things in Excel easy to understand and you always present it in a professional way 👍 So it's always magical when watching your Excel videos, Leila 😊
@LeilaGharani
4 жыл бұрын
So nice of you! Thank you.
Amazing! It's so helpful to see where all these different commands are. Excel's features are so underused! Thank you so much!
@LeilaGharani
4 жыл бұрын
Glad it was helpful Karina!
Great, useful tips and very well presented as per usual Leila! Thanks for sharing :)
Another great video! I have little experience with Power Query, but will be jumping after seeing this video. Thank you so much for all the great content you provide!
Thank you for sharing. You explain very well!! God bless you
Leila you are the best ❤️ Thanks for sharing this video We are always learning something new every Thursday 😊
Bonjour Leila. Again, thank you for all your excel lessons. I have been following them about a week ago, and have learnt so much. Every day I look up your tutorials and practice them. It's been most educational. Merci beaucoup. Greetings from France.
@LeilaGharani
4 жыл бұрын
Wonderful Ann! Avec plaisir :)
Absolutely Amazing ... thanks Liela
Super practical and useful examples,as usual! Thank you, Leila!
@LeilaGharani
4 жыл бұрын
Glad you think so!
Always delivering new stuff from what i know. Thanks and keep it up
An excellent, thoughtful example, Leila.
Leila you are Always the best!!!!
i dont use power query at all... but i will now use it to formate my imported tables in a proper and usable format. Thanks !
Appreciated your kind efforts.
Thank you for this great video. Your tutorials have helped me so much in excel and I'm now known as the "excel guy" but it's you who should be getting the praise
Thanks for the wonderful recap of a few of the great methods available via power query.
Thanks a lot and your training videos are awesome :)
Gosh you are just so amazing. Ive learnt so much from you last 6 months ! Thank you so much for helping everyone. The way you explain is beautiful
@LeilaGharani
4 жыл бұрын
Wow, thank you!
This just blew my mind. Great work.
@LeilaGharani
4 жыл бұрын
Glad you liked it!
Very good Leila, great tips and thanks for the spreadsheet available. Thank you.
@LeilaGharani
4 жыл бұрын
My pleasure Luciano!
Hi Leila, You are awesome your every session is so educative for everyone and your miraculous presentation is an icing on cake. Thanks for putting your great efforts and spreading the light of your spritual knowledge.
@LeilaGharani
4 жыл бұрын
You are so welcome!
Thanks Leila. Power Query is so much easier although building the formula is more fun : ) : )
@LeilaGharani
4 жыл бұрын
Haha! Yes, that can be fun too. It's great to have options :)
Very helpful and useful! Thank you very much.
My first class Power Query. Really enjoyed. Thanks Leila
@LeilaGharani
4 жыл бұрын
My pleasure!
Your videos are so super easy to follow. In fact, even if the audio is muted, it is easy to follow. I eagerly wait for your videos each week. Thx a lot.
@LeilaGharani
4 жыл бұрын
Thank you so much 😀
Hi Leila.. great video! You are making me better at Power Query with each one :)) Thanks for the great examples, instruction and courses from your channel and web site. Thumbs up!!
@LeilaGharani
4 жыл бұрын
Thank you, Wayne!
You are a godsend sister. Thanks a lot 🙏 I'm Nessim from Brussels. Cheers
Power Query is really a revolution. I am so happy that you are creating these courses, you are so professional in everything you do!
@LeilaGharani
4 жыл бұрын
Wow, thank you!
Thank you great instructions!
I love Power Query by You Leila, thanks :)
You're awesome. Always sharing clever tips in a clear and unambiguous way. A true MVP. Thank you.
@LeilaGharani
4 жыл бұрын
I appreciate that!
Brilliant, so useful and professionally presented. Thanks!
@LeilaGharani
4 жыл бұрын
Glad you enjoyed it!
You are amazing Leila, You can't imagine how this Video is very important to millions of users .. thanks thanks thanks a lot ..
@LeilaGharani
4 жыл бұрын
Glad you think so!
Saved my day...Excellent...
Love watching your videos, you make it look real easy.. . Thank you
@LeilaGharani
4 жыл бұрын
Thanks for watching!
Hi dear Leila, I already completed the power query course with someone else. BUT the way you teach is so clear and concise. I am so grateful for the lessons that you taught me.
@LeilaGharani
4 жыл бұрын
You're very welcome!
Many Thanks Leila ♥
Thanks a lot. Brilliant
Love it, thanks
Thank you Leila. I learn so much from you. I was having a hard time trying to extract text from a spreadsheet. Thanks to your video I was able to do it and I learned something new, Power Query, thanks again.
@LeilaGharani
2 жыл бұрын
Glad it was helpful!
Your are beauty with brain. So easily and effectively teaches the complex problem.
@LeilaGharani
4 жыл бұрын
😘
Thanks Leila: more magic!
@LeilaGharani
4 жыл бұрын
More magic to come :)
Fantastic example, thank you! :)
@LeilaGharani
5 ай бұрын
Glad you liked it!
The most beautiful ever. Your lessons are so captivating.
@LeilaGharani
4 жыл бұрын
Wow, thank you!
Thank you Leila, you are the best...
@LeilaGharani
4 жыл бұрын
You're welcome 😊
This is very helpful. Thanks
Excellent tips n solutions to avoide lengthy formulas and great level of teaching and presentation. That's why you are the best excel teacher on youtube.
@LeilaGharani
4 жыл бұрын
So nice of you
Thanks ليلى
So useful! I did exactly the same thing today with Macros but it's way easier with Get and Transform. Thank you!
@LeilaGharani
4 жыл бұрын
It really is!
That was great, thanks so much!
@LeilaGharani
4 жыл бұрын
You're very welcome!
Awesome. Very useful.
Always get to learn new things..Thanks Leila
@LeilaGharani
4 жыл бұрын
My pleasure!
Great Leila! You saved my day! Wanted these ideas for a data task and found it just in time! Thanks! :-)
@LeilaGharani
4 жыл бұрын
Glad it was helpful!
i really love YOU... explanation very well explained. not very fast and step by step. a few years ago I wasted so much time resolving situations like this. And now I see how simple and FAST it can be .. THANK YOU
@LeilaGharani
4 жыл бұрын
You're welcome!
It's helpful to me a lot. Thanks for sharing the knowledge
@LeilaGharani
4 жыл бұрын
It's my pleasure
Excellent teaching
You're great as usual.
Thanks Leila. Power Query is fantastic.
@LeilaGharani
4 жыл бұрын
It really is Matt!
Wow a whole new world of Excel! Extremely helpful!!
@LeilaGharani
4 жыл бұрын
It really is. One of the best tools in Excel!
Excellent teacher of excel
Thanks Leila. That helps a lot.
@LeilaGharani
4 жыл бұрын
You're welcome 😊
Hi Leila!Power Query And Power BI Make Complex Work/Reporting So Much Easier Especially When You Learn To Use DAX Formulas..Really Great Tutorial Thank You :)
@LeilaGharani
4 жыл бұрын
Very true 😄 Glad you like the video.
Thank you.
You always are very educational and show how it can be applied in practice.
@LeilaGharani
4 жыл бұрын
Glad you like the tutorials.
Greats Tips Leila... Thanks. 🇨🇱
@LeilaGharani
4 жыл бұрын
Glad you think so Miguel!
Thank you
Thank you
This is what is I am working currently, good to use
mind blown, as always
Your timing of this video is the same as your fashion sense, IMPECCABLE! I have a data set similar to the one in the video and these techniques will simplify my task. Btw pink looks good on you.
@LeilaGharani
4 жыл бұрын
Glad the timing and choice of clothes was appreciated 😊
thank u so much
Excel Power Query, one more feather in the cap. I personally like find delimitor from the end. Thanks for the video Leila. Cannot wait to see more videos on Excel Power Query
@LeilaGharani
4 жыл бұрын
There will be more Sachin :)
Long time back, I was tackling this problem via formula, it took me two days and result in total failure. Never thought it is as easy as this. Thank you very much Liela...
@LeilaGharani
4 жыл бұрын
Power Query can be your best friend for tasks like this :)
@rajanghadi2337
4 жыл бұрын
Not sure why it would be difficult using function. Yes, with power query it's most simple, but even with functions it's not difficult (especially this problem) if our logic is clear with functions.
Hi Leila, Thank you so much for this educative and insightful video. Great work.. Stay Safe, Stay Healthy. (I have subscribed all your courses in Udemy). Great Fan of your knowledge. you are my excel guru.
@LeilaGharani
4 жыл бұрын
Glad to hear it!
It's video most useful to us...!!! 👍👍 Great work mam....!!!
Leila, you videos are very usefull and simply....congratulation
@LeilaGharani
3 жыл бұрын
Thank you! 😃
Great video Leila! I love PQ
@LeilaGharani
4 жыл бұрын
The best!
This is the most simplest way. Power Query bring so much to the table.🙂 👍🏼 Video
@LeilaGharani
4 жыл бұрын
Glad you think so!
Thanks so much, Ive learned so much from your shared. Keep it up pls
@LeilaGharani
4 жыл бұрын
Thanks, will do!
Amazing!
Thanks Leila. Good Morning
@LeilaGharani
4 жыл бұрын
Good morning!
This is awesome. This will help me in my email process to assign casses. Thanks a lot🙏🤗
@LeilaGharani
4 жыл бұрын
My pleasure.
Dear Laila, Thank you very much for you knowledge. It is awesome to know more and more what Excel can do...
@LeilaGharani
4 жыл бұрын
My pleasure!
Great effort!!!
@LeilaGharani
3 жыл бұрын
Thank you! Cheers!
Wow thanks 🙏
Actually, so far so good 👍
Great stuff as always
@LeilaGharani
4 жыл бұрын
Appreciate that
Awesome 👍
Good info Leila
mind blowing!
One thought: mention which version you're using. Have learned so much from you, cheers!
@LeilaGharani
4 жыл бұрын
Thanks John. I'll make sure to mention the requirements for the course.
@mezianeremila454
4 жыл бұрын
Good suggestion...
I m really big fan of your.. your vedio always supports me in my work..
@LeilaGharani
4 жыл бұрын
Glad to hear that
You are the best
Power Query is a game changer. Once I learnt it, I only used formulas for quick and dirty analysis. Anything long term, it's all on Power Query
Thanks Leila
Gr8 Whenever I Look in Excel ....... I think LG Thank you
@LeilaGharani
4 жыл бұрын
😘
@juarezr61274
4 жыл бұрын
Life is Good :)
Muito bom o conteúdo.
So good! You are such a boss
@LeilaGharani
4 жыл бұрын
Thanks Nathan!