REPLACE Function to Insert a Dash Into Text. Flash Fill Too. Excel Magic Trick 1639

Download Excel File:
Learn how to use REPLACE rather than LEFT and RIGHT Functions to insert a dash into Text. Also see Flash Fill to Insert a Dash into Text.
1. (00:01) Introduction
2. (00:15) Learn how to use REPLACE rather than LEFT and RIGHT Functions to insert a dash into Text.
3. (01:16) Also see Flash Fill to Insert a Dash into Text. See how to do Flash Fill with; 1) Keyboard, 2) Ribbon Button, 3) Ghost List.
4. (02:08) Summary and End Video Links

Excel,Highline College,Mike Girvin,excelisfun,excel is fun,excel fun,excel magic,Excel Formulas,Excel Functions,formulas and functions,Excel Magic Trick 1639,EMT,EMT 1639,REPLACE Function to Insert a Dash Into Text,REPLACE Function,Excel REPLACE Function,REPLACE to Insert Text,How to Insert Text into an ID,Excel Insert Text,Flash Fill to Clean Data,Flash Fill to Insert a Dash,Text Formulas,Formula to Insert a Dash,Excel Function to insert dash,