Smart Fill
What This Does
Smart Fill recognizes patterns—extracting first names from emails, formatting phone numbers—and suggests auto-completion.
Why It's Useful
Flash fill in Excel, same idea: repetitive string manipulation should not be manual.
How to Do It
- Enter examples in adjacent columns showing the pattern
- Sheets may suggest Smart Fill—press Enter to accept
- Or use Data → Split text to columns for delimited data
- Works for names, dates, and extracted substrings
Try This Now
Type two transformed examples and accept a Smart Fill suggestion.
Mental Hook: Type two, Sheets fills the rest.
