New Feature in Microsoft Excel Since Version 2013 – It’s called Flash Fill
If you deal with lots of data lists and find yourself doing a lot of cleaning and tiding up as well as having Microsoft Excel version 2013 or higher, then you will have this new feature called Flash Fill. Prior to this version you will need to use the usual Text to Column feature found under the Data Tab. When you have data like an email address you may be needing to display only the surname. In the example below the first and surname is separated by a full stop. With Microsoft Excel’s Flash Fill you can start the ball rolling by typing in the next column for example the surname “Pisani” then fill the contents of the cell down. Initially the data should repeat from the AutoFill smart tag that appears select Flash Fill this will start to pick up the surname from each row.
For example, if you have: firstname.lastname@example.org you might want to extract each surname.
Microsoft Excel now has a feature called Remove Duplicates found under the Data Tab. Just take note the result of the duplicates does not get re located onto a separate sheet so once you press that button – Remove Duplicates that’s it, you are left with the clean data.
Offering Customized Computer Training Courses, we come to you.
Some of my clients in the area are Hino, Toyota, Taren Point Hotel, Civic, Caltex Refineries, Sutherland Shire Care Support Service. Visit website reviews