Download: http://people.highline.edu/mgirvin/ExcelIsFun.htm
The Amazing Flash Fill Excel 2013 Feature will Extract, Concatenate (Join), Insert or Reverse Data (Text, Dates, Numbers, Time)

See how to:
1. Flash Fill Keyboard: Ctrl + E to Extract First and Last names (Remember: Flash Fill does not recognize changes in source data, but formulas do.)
2. Extract First Letter of First or First Letter of Last name when data is separated by space.
3. Extract Initials
4. Extract First 2 characters of First
5. Extract First 3 characters of First
6. Extract First 4 characters of First
7. Extract First 5 characters of First
8. Extract First 6 characters of First?? - Actually, it tells Excel: First Name and Initial of Last
9. Extract with Dots
10. Extract with @ symbol
11. Join or Concatenate Text
12. Extract Year, Month or Day from Date
13. Extract Pennies from Sales Number
14. Extract Integer from Sales Number
15. Extract Dollars from Sales Number
16. Concatenate Date and Dollars
17. Insert Comma
18. Insert Text
19. Extract Hours from Time
20. Extract Minutes from Time?
21. Extract and Insert with Text: Get First Initial with period and Last Name
22. Reverse Last and First Name
23. Reverse Last and First Name and Insert Comma