excelisfun | Excel Text To Columns or Split to Rows: Worksheet Formula or Power Query? Excel Magic Trick 1795 @excelisfun | Uploaded 2 years ago | Updated 1 day ago
Download Excel File: https://excelisfun.net/files/EMT1795-1797.xlsx
Buy excelisfun new book at Mr Excel Web Site: https://excel.bookstore.ipgbook.com/microsoft-365-excel--the-only-app-that-matters-products-9781615470709.php
Buy excelisfun new book at Amazon: https://www.amazon.com/Microsoft-365-Excel-Calculations-Analytics/dp/1615470700
Learn how to use an Excel formula (TEXTSPLIT or FILTERXML functions) to split text from a cell based on delimiter to a vertical Column. This is Like Text To Columns.
Topics:
1. (00:00) Introduction
2. (00:18) TEXTSPLIT function
3. (01:28) FILTERXML function
4. (01:49) Power Query
5. (02:38) Summary
6. (02:43) Closing, Video Links
FILTERXML Function to Split Text into Cells. Excel Magic Trick 1685
https://www.youtube.com/watch?v=kDoaWCZ4VBM
Download Excel File: https://excelisfun.net/files/EMT1795-1797.xlsx
Buy excelisfun new book at Mr Excel Web Site: https://excel.bookstore.ipgbook.com/microsoft-365-excel--the-only-app-that-matters-products-9781615470709.php
Buy excelisfun new book at Amazon: https://www.amazon.com/Microsoft-365-Excel-Calculations-Analytics/dp/1615470700
Learn how to use an Excel formula (TEXTSPLIT or FILTERXML functions) to split text from a cell based on delimiter to a vertical Column. This is Like Text To Columns.
Topics:
1. (00:00) Introduction
2. (00:18) TEXTSPLIT function
3. (01:28) FILTERXML function
4. (01:49) Power Query
5. (02:38) Summary
6. (02:43) Closing, Video Links
FILTERXML Function to Split Text into Cells. Excel Magic Trick 1685
https://www.youtube.com/watch?v=kDoaWCZ4VBM