09/02/2026
Excel's Flash Fill is one of the most underused features in the app. Type an example of what you want in the first row, like splitting a full name into first and last, then start typing the second row. Excel will often guess the pattern and offer to autofill the rest. Hit Enter to accept, or trigger it manually with Ctrl+E if it doesn't kick in automatically.
It handles reformatting phone numbers, extracting parts of text, combining columns, fixing inconsistent capitalization, and even pulling domains out of email addresses, all without a single formula. The catch is that it works off the pattern you demonstrate, so if your data is inconsistent partway through, check the results before trusting them. Still, for one time cleanup jobs on messy exports, it beats writing and debugging a nested text formula every time.
It also works in reverse for combining data, like merging a first and last name column into one, or joining a city and state into a single address line, just by typing the combined example once. Since Flash Fill inserts static text rather than a live formula, it won't update automatically if the source data changes, so rerun it if you refresh the underlying export.