Split Full Names in Seconds with This Excel Shortcut
Still separating first and last names manually in Excel? 😓
Save yourself time with Flash Fill (Ctrl + E) — the fastest way to split names without formulas!
📌 How it works:
✅ Type the first name in a new column
✅ Press Ctrl + E, Excel fills the rest
✅ Do the same for last names in the next column
✅ Done! No functions. No dragging. Just clean data.
🔥 Perfect for formatting contact lists, CRM exports, or survey responses.
💬 Let us know if this trick was new to you, and don’t forget to like, subscribe, and hit the bell for more Excel magic!
#exceltips #flashfill #names #excelshortcuts #spreadsheet