How to separate first and last name in Excel column
A free Office suite fully compatible with Microsoft Office
You can use Excel for so much more than formulas and data management. It's also an excellent way to manage your contacts. However, you'll probably need to know how to separate first and last names in Excel.
If you import all of your contacts from another source, you'll likely end up with a first and last name in a single cell. There's nothing wrong with that, but separating first and last name can help you organize them better. Here are some steps on how to get started.
Separating your contacts' first and last names lets you take advantage of email features that help you customize your content! You can add a name to your subject line, include a personalized greeting, and add contact details to the body of your email.
Separate First and Last Name by Split columns
Select the target range in WPS Spreadsheet
Note: Hyphenated first or last names are treated as a single unit and you only need to add one column. If you have contacts with compound names that aren't hyphenated, for example, Mary Margaret or John Michael, or your spreadsheet includes middle names, or even couples, add an extra column for each part of the name. For example, add two columns for Mary Margaret Jones, or if you're collecting middle names, add three columns for John Michael Alexander Smith, or if you have couples, add four columns for Mary and John Jones..
Click Data → Text to Columns
Choose Delimited in the interface of 'Convert Text to Columns Wizard - Step 1 of 3'
In the interface of 'Convert Text to Columns Wizard - Step 2 of 3', select the delimiters in terms of your demands.
Click Finish in the interface of 'Convert Text to Columns Wizard.
Non-hyphenated, compound names are broken into two columns and have to be recombined into the First Name column manually. When you're done combining, delete the empty column. If you have a column for Middle Name, you can create a custom field for it when you import your file into Constant Contact.
If you have columns that you don't need, you can just delete them or consolidate them before uploading your spreadsheet into Constant Contact.
Compound names without a hyphen (Mary Margaret) need to be manually updated so that both parts of the name are in the First Name column.
Middle names (Mary Margaret Jones) aren't recognized as a standard contact heading, and can either be added to the First Name column, or you can keep the Middle Name column and add it as a custom field during the import process.
Couples (Mary and John Jones) that were previously added as one contact now need to be split into two separate rows. Each half of the couple should have their own unique email address. The And column can be deleted. If you only have a single email address, you can combine the first names (Mary and John) into the First Name column
Did you learn how to Separate First and last Name in excel? You can follow WPS Academy to learn more features of Word Document, Excel Spreadsheets, and PowerPoint Slides.
You can also download WPS Office to edit the word documents, excel, PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience.
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. Check if value is in list in Excel (3 easy methods)
- 3. How to Copy File Names in Excel from a Folder?
- 4. How to add text to beginning or end of all cells in Excel
- 5. How to color cell based on value in Excel?
- 6. How to compare two excel sheets and highlight differences