TUG Tips & Tricks: General

TUG Tip -- General Industry

Tuesday, January 29, 2019   (0 Comments)
Posted by: Mary Jo Hamik, Beckenhauer Construction, Inc.
Share |

TUG Tip of the Week: 

Excel Flash Fill: 

Check out the YouTube channel for video instructions to this useful tip! 

If you don’t want to write a formula in Excel to extract desired data, you can use Flash Fill.

In this example, Zip Codes were entered in Excel in various ways. To strip the zip code out of the entered data you can copy the desired data and paste into a new column. Click Flash Fill on the Data tab and the data automatically fills. This could also be used to separate first and last names. This tip was discussed at a recent Excel Tips and Tricks webinar by an attendee. A great tip that we hope you’ll find useful.

** Turn on subtitles (CC) for step-by-step instructions. **


Have a comment or question?  Post it below.

Have a tip to share?  Submit a tip here

About Us Membership Knowledge Exchange Events Resources
About Join Now Advocate to Sage Community Calendar Get Connected ⇓
Leadership ⇓ What Members Say User Communities Regional Workshop Affiliate Members
TUG Board of Directors Member Orientation Committees National Conference Associate Members
TUG Past Presidents Get Involved Advertise with TUG
TUGweb Tutorials
TUG Staff Follow Us on Social Media

Contact Us Get Rewarded

Career Center

3525 Piedmont Rd Building 5, Suite 300 Atlanta, GA 30305 Phone: (866) 846-0999

Email: info@TUGweb.com

Connect with TUG