Discover the EASY way to Transform Text in Excel (No Formulas - just Power Query)
11 Jun 2020 Excel Power Query (Get & Transform)
Join 300,000+ professionals in our courses: https://www.xelplus.com/courses/
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
But fortunately you have another option: Power Query aka Get and Transform. With this magic tool you can achieve this by just clicking a few buttons. And if this was not already enough there is another upside: Once you've setup the logic in Power Query, when new data comes in all you have to do is to click Refresh. And you're done!
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.
Download the Workbook: https://www.xelplus.com/excel-text-transformation-power-query
Power Query Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyyKV86N7i0q9TfYNN8bBjX-
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Microsoft 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
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!
#MsExcel #Excel #LeilaGharani
-
LIVE
Akademiks
16 hours agoAll Will Be Revealed! Drake vs Kendrick vs The Riddler. Who Lied, Who Snaked, Mole Finally Revealed!
11,175 watching -
2:02:41
stevewilldoit
3 hours agoGIVING AWAY A MILLION $ IF I WIN A MILLION $!!!
10.3K51 -
1:08:38
Russell Brand
2 days ago“You’re Going To Get KILLED!” Mike Benz EXPOSES CIA Secrets Like NEVER Before - Stay Free #363
299K788 -
1:35:13
Roseanne Barr
1 day ago $70.97 earnedKeep My Name Out Yo M*Therf*Cking Mouth! | The Roseanne Barr Podcast #47
112K309 -
1:19:00
Steven Crowder
3 days agoBradley Martyn and Vitaly's Hollywood Pedo Bust Goes Wrong! Guests: Alex Rosen | Vivek Ramaswamy
594K1.05K -
53:40
The Osbournes
5 days ago $1.07 earnedWould You Eat a Monkey? Osbourne's Wildest Meals
11K8 -
1:19:01
Steve-O's Wild Ride! Podcast
3 days agoMike The Situation Went To Prison & Owes Millions, But Remains Grateful - Wild Ride #213
9.7K3 -
9:45
RealReaper
1 day agoVelma is The Worst Show of 2024: Part 1
21K65 -
23:13
InfiniteWaters(DivingDeep)
1 day agoBiggest Solar Storm in 20 Years Could Cripple Internet, Phones, And Power Grids (Prepare Now!) 👁️
45.5K80 -
8:06
Brad Polumbo
1 day agoWoke TikToker is (accidentally) sexist!
44.9K26