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

Topics in this Video:

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

Microsoft

• TEXTSPLIT function
  The TEXTSPLIT function works the same as the Text-to-Columns wizard, but in formula form. It allows you to split across columns or down by rows. It is the inverse of the TEXTJOIN function.
  https://support.microsoft.com/en-us/office/textsplit-function-b1ca414e-4c21-4ca0-b1b7-bdecace8a6e7
• FILTERXML function
  The FILTERXML function returns specific data from XML content by using the specified xpath.
  https://support.microsoft.com/en-us/office/filterxml-function-4df72efc-11ec-4951-86f5-c1374812f5b7
• Informationen zu Power Query in Excel
  With Power Query (known as Get & Transform in Excel), you can import or connect to external data, and then shape that data, for example remove a column, change a data type, or merge tables, in ways that meet your needs.
  https://support.microsoft.com/de-de/office/informationen-zu-power-query-in-excel-7104fbee-9e62-4cb9-a02e-5bfb1a6c536a