Excel Text To Columns or Split to Rows: Worksheet Formula or Power Query? Excel Magic Trick 1795

Posted on by Annie D

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

ExcelIsFunSun, August 7, 2022 1:38am