How to Separate name in Excel with Flash Fill
Step 1: Open your Excel Spreadsheet
Step 2: Enter your First name in Cell B1 and Second Name in Cell C1
If your full names are in column A starting from cell A1, enter the first name of the first entry in cell B1 and the last name in cell C1.
Step 3: In cell B2, type the first name of the second entry
Step 4: Excel will suggest Flash Fill based on your pattern
Step 5: Press Enter to accept the suggestion
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