Download Excel File: Learn how to dynamically insert a dash between text and a number, four different ways: 1. (00:01) Introduction 2. (00:19) Flash Fill 3. (00:44) Worksheet Formula with REPLACE, MID, ROW, INDIRECT, ISNUMBER, MATCH and LEN Functions. 4. (04:08) Power Query: Split by Non-Digit to Digit and Merge Columns. 5. (05:31) Office 365 Worksheet Formula with REPLACE, MID, ISNUMBER, XMATCH and SEQUENCE Functions. 6. (06:05) Summary and End Video Links