What is Flash Fill in Excel?

An alternative to using Text to Column to extract the part that you need from a mix of data.

For example, if you have: analir.pisani@azsolutions.com.au you might want to extract each person’s surname.

Alternatively use Text to Column found under Data Tab.

  1. Type Pisani then fill down
  2. Click on the AutoFill Options smart tag
  3. Select Flash Fill
    (only available in version 2013 forward)



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

Basic Function

How to show all Formulas in Excel


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: Info@azsolutions.com.au m: 0414 417 059 www.azsolutions.com.au
This entry was posted in Excel. Bookmark the permalink.

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s