Power Query to Insert Dashes into Text. Flash Fill too! Excel Magic Trick 1638

Download Excel Text File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1638TextFile.txt Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1638Start.xlsx Download Excel Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1638Finished.xlsx Learn how to insert dashes into a text item using Power Query or Flash Fill. In Power Query learn how to split text by multiple positions and how to merge text in columns. 1. (00:01) Introduction 2. (00:26) Power Query 3. (01:25) Power Query split text by multiple positions 4. (01:55) Power Query Merge Columns 5. (02:31) Flash Fill 6. (03:17) Summary and End Video Links