Split & Organize Full Names in Excel
Budget: $10 – $30 USD
I'm in need of someone with advanced Excel skills to help me deal with a significant data cleanup task. Currently, I've got an Excel sheet grappling with the following issues:
- The first names and last names are mixed and stored in one column.
- These names lack a consistent format, with some having the first name come first, some the last, and all sorts of variations in between.
I have created sample corrections.
The task at hand is to separate these names into two distinct columns: one for first names, and another for last names. This will require expert attention as there are different configurations of the data that will need separating logic. The format for the separation isn't strictly defined, you're free to apply any setup that results in clear separation of first names and last names.
The ideal freelancer for this job should have:
- Proven experience in data cleanup within Excel.
- Excellent problem-solving skills to handle different data configurations.
- A keen eye for detail and accuracy, to ensure each entry is correctly split.
636 records. Tell me how long it will take you so that I estimate cost.
- The first names and last names are mixed and stored in one column.
- These names lack a consistent format, with some having the first name come first, some the last, and all sorts of variations in between.
I have created sample corrections.
The task at hand is to separate these names into two distinct columns: one for first names, and another for last names. This will require expert attention as there are different configurations of the data that will need separating logic. The format for the separation isn't strictly defined, you're free to apply any setup that results in clear separation of first names and last names.
The ideal freelancer for this job should have:
- Proven experience in data cleanup within Excel.
- Excellent problem-solving skills to handle different data configurations.
- A keen eye for detail and accuracy, to ensure each entry is correctly split.
636 records. Tell me how long it will take you so that I estimate cost.