How to Split Full Names with Text to Columns feature

Step 1: Open your Excel Spreadsheets

Open your Excel spreadsheet containing the listing of complete names you need to split.

Step 2: Select the Column Containing the Entire Names

Select the column containing the entire names. If your facts begins in cell A1, click on the letter A on the top of the column to pick out the whole column.

Step 3: Go to Data Tab

Navigate to the Data tab within the Excel ribbon.

Step 4: Select the Text-to-Column

In the Data Tools group, click on the Text to Column button. This will open the Convert Text to Columns Wizard.

Step 5: Select Delimeter and Click on Next

In the wizard, pick the option Delimited and click on Next.

Step 6: Choose Column Data Format

Choose the format for the separated data columns. You can both pick the General format or specify the layout for every column via selecting the suitable statistics type.

Step 7: Speicfy the Destination

Specify the Destination spot cells in which you need the separated records to be placed. You can pick out to update the existing facts or specify new cells.

Step 8: Click on Finish

Click Finish. Excel will now separate the whole names into man or woman first and closing name columns primarily based on the chosen delimiter.

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.