Watch this video by Mike Girvin AKA ExcelIsfun:
http://www.youtube.com/watch?v=qHkgJ...D7C5C90C5A2B78
Truly amazing feature for one-time cases or people who can't use Excel that well. my colleague recently just told me "how i wish Microsoft would make Excel easier for us to use". i love Excel & find it already easy to use. but it looks like she's been heard! i would still stick to formulas since they update along with new changes, but this is just awesome.
the FlashFill recognizes the pattern & applies it to the rest of the cells. these are the things he showed in the video:
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
Bookmarks