How to Separate Names in Excel using Find and Replace
Step 1: Copy the names of Name Column and paste it in Column FirstName Column
Copy the names of Name Column and paste it in Column FirstName Column
Step 2: Press Ctrl+H to open Find and Replace Box
Step 3 : Now type in Find what: * (space followed by the asterisk symbol) to find firstname
To Get fiirstname
Step 4: Click on Replace All
To Get LastName
Result
How to Separate First and Last Names in Excel? 4 Easy Methods
In Microsoft Excel, a common scenario unfolds that you’ve got a column filled with full names, and you’re having trouble splitting them into separate first and last name columns. The good news is, that there are several ways to achieve this task effectively. You can harness the power of Excel’s Text to Columns feature, and craft your formulas.
In this article, we’ll go through simple steps to separate first and last names in Excel, using some handy features that Excel provides.
Contact Us