1. Flash Fill: The Pattern Recognition Wizard How it works:
- Type an example pattern (e.g., splitting first/last names)
- Press Ctrl + E (Windows) or Cmd + E (Mac)
- Excel auto-fills remaining cells Use cases:
- Formatting phone numbers
- Extracting domain names from emails
- Creating custom ID numbers 2. Data [...]
Read more