How to Divide Name And Surname on Excel: A Step-by-step Guide
Are you tired of having long lists of names and surnames in the same cell, making it difficult to organize your contacts? Look no further! In this article, we will show you how to divide name and surname on Excel using various methods.
The Problem With United Names And Surnames
When you have a long list of personal contacts, it’s not uncommon to have names and surnames written in the same cell. This can make it challenging to organize your contacts and perform other tasks that require separate columns for names and surnames.
Method 1: Using The “Text in Columns” Feature
One way to divide name and surname on Excel is by using the “Text in Columns” feature. This feature allows you to split text into multiple columns based on a specified delimiter.
- Open your Excel file and select the cell or column containing the united names and surnames.
- Go to the “Home” tab and click on the “Text in Columns” button.
- Select the delimiter that is separating the name and surname (e.G., A blank space, comma, etc.).
- Choose where you want to split the text (e.G., Into two columns).
Method 2: Using The Formula Divide.Text
Another way to divide name and surname on Excel is by using the formula DIVIDE.Text.
- Select the cell containing the united names and surnames.
- Go to the “Formulas” tab and select the “Text” menu.
- Choose the “DIVIDE.Text” function.
- Enter the delimiter that is separating the name and surname (e.G., A blank space, comma, etc.).
Method 3: Using The “Find And Replace” Feature
If you have names and surnames written in the same cell and separated by a specific character (e.G., A comma or hyphen), you can use the “Find and Replace” feature to divide them.
- Open your Excel file and select the cell or column containing the united names and surnames.
- Go to the “Home” tab and click on the “Find and Replace” button.
- Type in the specific character that is separating the name and surname (e.G., A comma).
- In the “Replace with” field, type in a blank space.
- Click “Replace All” to split the text into multiple columns.
Method 4: Using The “Text Split” Function
Excel also has a built-in function called Text Split that allows you to divide text into multiple columns based on a specified delimiter. This method is similar to Method 1, but uses a formula instead of the “Text in Columns” feature.
- Select the cell containing the united names and surnames.
- Go to the “Formulas” tab and select the “Text” menu.
- Choose the “Text Split” function.
- Enter the delimiter that is separating the name and surname (e.G., A blank space, comma, etc.).
Conclusion
Dividing name and surname on Excel can be achieved using various methods. The most suitable method for you will depend on your specific needs and preferences.
Whether you’re using the “Text in Columns” feature, the formula DIVIDE.Text, the “Find and Replace” feature, or the Text Split function, these methods are sure to help you manage your contacts more efficiently.
Frequently Asked Questions (FAQs)
- Q: Can I Use These Methods on my Smartphone or Tablet?
- A: Yes! These methods can be applied using the Excel app for Android and iOS devices.
- Q: How do I Use The “Find And Replace” Feature?
- A: To use the “Find and Replace” feature, go to the “Home” tab, click on the “Find and Replace” button, type in the specific character that is separating the name and surname, and replace it with a blank space.
- Q: Can I Divide Names And Surnames in Multiple Cells?
- A: Yes! Using any of these methods, you can split the text into multiple columns or cells as needed.
- Q: How do I Use The Formula Divide.Text?
- A: To use the formula DIVIDE.Text, select the cell containing the united names and surnames, go to the “Formulas” tab, choose the “Text” menu, select the “DIVIDE.Text” function, enter the delimiter that is separating the name and surname (e.G., A blank space, comma, etc.), And specify where you want to split the text.
- Q: Can I Divide Names And Surnames in a Single Cell?
- A: Yes! Using any of these methods, you can keep the united names and surnames in the same cell by not splitting them into multiple columns or cells.
Additional Resources
If you’re new to Excel or need more guidance on how to use these methods, we recommend checking out our other tutorials and guides:
- How to Use Excel on Android: A Step-by-Step Guide
- How to Use Excel on iPhone and iPad: A Step-by-Step Guide
- Excel Tutorial for Beginners




