Discover the EASY way to Transform Text in Excel (No Formulas - just Power Query)
Complete Excel Power Query course: https://courses.xelplus.com/p/excel-power-query
*** Note: On XelPlus you will get additional bonuses that are not available on other platforms. Check the course landing page for more info.
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
Видео Discover the EASY way to Transform Text in Excel (No Formulas - just Power Query) канала Leila Gharani
*** Note: On XelPlus you will get additional bonuses that are not available on other platforms. Check the course landing page for more info.
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
Видео Discover the EASY way to Transform Text in Excel (No Formulas - just Power Query) канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Microsoft Power BI: Deep dive into DAX evaluation context - BRK3060](https://i.ytimg.com/vi/teYwjHkCEm0/default.jpg)
![Power Query Tutorial - What is it, how to use it & 4 complete examples + Free download](https://i.ytimg.com/vi/PiFAa_jjaEI/default.jpg)
![3 EASY Ways to Find and Remove Duplicates in Excel](https://i.ytimg.com/vi/ADArCWLz55Y/default.jpg)
![How To Import & Clean Messy Accounting Data in Excel | Use Power Query to Import SAP Data](https://i.ytimg.com/vi/TjGbOoKvZ7M/default.jpg)
![](https://i.ytimg.com/vi/GxyZKHr86oQ/default.jpg)
![How to use Microsoft Power Query](https://i.ytimg.com/vi/0aeZX1l4JT4/default.jpg)
![When You Should Use the New Excel LET Function](https://i.ytimg.com/vi/D5HgyE06pXs/default.jpg)
![Searchable Drop Down List in Excel (Very Easy with FILTER Function)](https://i.ytimg.com/vi/Z-h2UER3b_0/default.jpg)
![Master Excel's SUMPRODUCT Formula](https://i.ytimg.com/vi/lzjc_eEISe8/default.jpg)
![Easily Fix Dates Formatted as Text with Power Query](https://i.ytimg.com/vi/0RN3FZv3w84/default.jpg)
![How to Import Emails From OUTLOOK to EXCEL & why you want to do that!](https://i.ytimg.com/vi/apBglZR9W60/default.jpg)
![Properly Convert PDF to Excel](https://i.ytimg.com/vi/p2304BjvrB8/default.jpg)
![How to Combine and Repeat Blocks of Text n Times in Excel (NO Copy Paste and NO Formulas)](https://i.ytimg.com/vi/9HpAWDi2y_E/default.jpg)
![How Power Query Will Change the Way You Use Excel](https://i.ytimg.com/vi/6lBqYInBldk/default.jpg)
![5 Excel Functions YOU NEED in 2021](https://i.ytimg.com/vi/_EWcAR_Hkvg/default.jpg)
![4 SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 1](https://i.ytimg.com/vi/tGY70sdpaLc/default.jpg)
![Quick Excel Trick to Unstack Data from one Column to Multiple Columns](https://i.ytimg.com/vi/rscXNUlRsH0/default.jpg)
![Easiest way to COMBINE Multiple Excel Files into ONE (Append data from Folder)](https://i.ytimg.com/vi/fHFUh6EhBcw/default.jpg)
![When Should you Use the Hash Sign (#) in Excel Formulas?](https://i.ytimg.com/vi/0S5lPoXHX_c/default.jpg)
![Excel 101: Basic Text Analysis and word clouds using pivot tables and other Excel tricks](https://i.ytimg.com/vi/WTxAP0PL1sc/default.jpg)