How to Use Flash Fill in Excel
Use Flash Fill in Excel to split, combine, and clean repeated text patterns without writing formulas for every column.
Flash Fill in Excel detects a pattern from your example and fills the rest of the column for you. It is useful when names, IDs, addresses, SKUs, or messy exports need a quick cleanup and the pattern is obvious enough for Excel to infer.
Use Flash Fill for one-time cleanup. Use formulas or Power Query when the workbook needs a repeatable transformation.
How to use Flash Fill
Step 1. Put the messy source values in one column.
Step 2. In the next column, type the cleaned result you want for the first row.
Step 3. Start typing the second result. Excel may preview the rest of the column.
Step 4. Press Enter to accept the preview, or use Data -> Flash Fill.
The keyboard shortcut is Ctrl+E on Windows.
Example: split client names
Suppose column A contains client names like Jordan Lee - Retail, and you only want the client name.
Type Jordan Lee beside the first row, then run Flash Fill. Excel should fill the rest of the names if the pattern is consistent.
This is useful before loading contacts into a CRM lead tracker or cleaning customer names for a sales pipeline.
Example: build invoice labels
Flash Fill can also combine fields. If column A has client names and column B has invoice numbers, type a label like Jordan Lee INV-1042 in the first output row.
Excel can infer the pattern and create the remaining labels without a CONCAT or TEXTJOIN formula.
That works well for quick cleanup in an invoice template when labels need to be readable but the sheet does not need a permanent formula.
When Flash Fill breaks
Flash Fill depends on examples. If the source data has mixed formats, extra spaces, missing separators, or inconsistent casing, Excel may fill plausible but wrong values.
| Problem | What happens | Better approach |
|---|---|---|
| Mixed name formats | Some names split incorrectly | Use formulas or review manually |
| Missing delimiters | Flash Fill guesses | Standardize the source first |
| Repeatable import | Cleanup must be redone | Use Power Query |
| Audit required | Logic is hidden | Use formulas with visible steps |
WATCH OUT
Review the inferred pattern
Flash Fill infers a pattern from the examples you type; it does not understand the business meaning of every row. Give it two or more representative examples, including a likely edge case, then inspect the filled column before replacing the source. Names with suffixes, addresses with apartment numbers, and inconsistent IDs are common places where a plausible-looking result is wrong.
Keep the original field until the output is approved. Filter for blanks and unusual lengths, compare a sample against the source, and use a formula or Power Query instead when the transformation must refresh with future imports. Once accepted, paste values only if the new column is intended to be independent of the original data.
The Griddy way
Flash Fill is fast, but it is not a workflow when the same messy export arrives every week.
"Clean this customer export into first name, last name, company, and source columns, then flag rows where the pattern looks inconsistent"
Griddy can split the fields, keep the cleanup visible, and point out rows that need human review instead of silently guessing.
Sources
Do this with AI
Turn the instructions into a finished spreadsheet.
Tell Griddy what you need in plain English, then inspect and keep editing the result in the browser, Excel, or Google Sheets.
Use this on real templates
Use cleaned text in customer and billing workflows
Flash Fill is most useful when messy names, labels, IDs, and notes need to become structured fields before they feed a tracker or invoice.
CRM Lead Tracker
Track contacts, lead source, owner, next due date, and follow-up status in one lightweight CRM sheet. Keep hot opportunities and stale leads visible without paying for heavy sales software.
Open templateSalesSales Pipeline
Track deals by stage, owner, value, and next move in one lightweight pipeline sheet. Keep close dates, weighted forecast, and rep follow-ups visible without needing a full CRM.
Open templateFinanceInvoice Template
Professional invoice template with automatic subtotal, tax, and total calculations. Customise with your logo and send in minutes.
Open template