Separating Data In Microsoft Excel

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: 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

Related Topics

Short Cut key for AutoSum

How to remove duplicates in Excel

Find and Replace Formatting

About Customised Computer Courses Sydney - Sutherland Shire M 0414 417 059

On-Site customised computer training courses Sydney - Sutherland Shire. Excel, Word,Power Point, Access, Outlook, Visio, Publisher, Excel VBA e: m: 0414 417 059
This entry was posted in Excel and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s