Скачать или смотреть How to Separate First and Last Names in Excel

If you’ve been handed a massive list of names and told to split them into first and last names, don’t panic. This video shows you how to separate names in Excel using two simple methods: Text to Columns and Flash Fill. Both approaches are fast, beginner-friendly, and work perfectly whether you’re handling 10 names or 10,000.
We start with the classic built-in tool: Text to Columns. You’ll learn how to select your entire list, move to the Data ribbon, and open the Text to Columns wizard. From there, you’ll see exactly which settings to turn on so Excel knows how to split your names correctly.
➡️ Head to the Data ribbon
➡️ Click Text to Columns
➡️ Choose Delimited
➡️ Select Space (or Comma + Space if needed)
➡️ Choose where your new data should go
➡️ Click Finish
This method is perfect for clean splits where every name follows the same structure. You’ll see how to avoid overwriting your original data, how to choose the correct destination cell, and how Excel instantly creates a separate first-name and last-name column.
Next, you’ll learn the faster, more flexible option: Flash Fill. This lets Excel learn the pattern from just a couple of typed examples. Once Excel sees what you’re doing, it fills the entire column instantly.
➡️ Type the first two first names manually
➡️ Press Ctrl + E to activate Flash Fill
➡️ Repeat for last names
➡️ Use Flash Fill again anywhere you need Excel to follow a pattern
Flash Fill is ideal when names vary or when you want the fastest solution possible. No formulas, no dragging, no complexity — just instant results.
You’ll also see how Flash Fill handles multiple examples, tricky names, and repeated patterns. It even works when the first names and last names are in separate columns and you need Excel to finish the job.
This tutorial covers popular search topics such as how to split names in Excel, how to extract first names, how to extract last names, Excel Flash Fill tutorial, and Excel Text to Columns guide — all explained in simple plain English.

If you found this video helpful, don’t forget to:
➡️ Subscribe for more Excel tips and tutorials.
➡️ Like the video to help more people find it.
➡️ Check out related resources here:
   / @articstream  

Related searches you might find useful:
how to delete duplicates in excel, excel remove duplicates but keep one, find duplicate values in excel, clean data in excel, data cleaning tutorial, excel tips for beginners, excel data tools

Support this creator by dumping coins into this book: https://www.amazon.co.uk/Surely-We-Ca...