Loading...

Excel 2013 Flash Fill : 23 Amazing Examples (Preview #7) (Excel Magic Trick 955)

56,224 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Jul 25, 2012

Download: http://people.highline.edu/mgirvin/Ex...
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

Loading...

Advertisement
When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...