Use Flash Fill in Excel to split or join text
Draft. Not published yet.
Flash Fill fills a column when Excel can see the pattern in what you typed. It’s handy for splitting first and last names, joining two columns into a full name, or reformatting a list of phone numbers or IDs.
Example: column A has first names, column B has last names, and you want full names in column C.
- In C2, type the first full name (for example,
Jane Doe) and press Enter. - In C3, start typing the next one. If Excel shows a preview of the rest of the column, press Enter to accept it.
- If there’s no preview, select the next cell and press Ctrl+E, or go to Data > Flash Fill.
Always scan the results. Flash Fill is pattern-matching, not a formula, so it can miss odd rows. If the list later changes, the Flash Fill column won’t update on its own the way a formula would.
If nothing happens, Flash Fill may be turned off. In Windows Excel, check File > Options > Advanced > Editing options > Automatically Flash Fill. (On Mac Excel, the path is Tools or Excel > Preferences / Options, then Advanced.) You can still run it by hand with Ctrl+E or the Data tab.