Hi
I have an exported list of names and dates in organisation. The names are different format, they can be full name or initial and surname or first middle and last name etc which means I have duplicates when using a pivot table.
Example for all same person
Bob Smith
B. Smith
Bobby Smith
My current fix is to sort alphabetically and drag down against each person with the first available name, then again with next person, so on and on, which takes time with several staff.
Is there a faster way to do this, i.e, either to correct or to lookup against Bob Smith on a master and match and replace as an example?
I have also looked at extracting surname and then doing a lookup with limited results.
Any assistance on fastest way to "cleanse the list" would be appreciated.
thanks in advance
I have an exported list of names and dates in organisation. The names are different format, they can be full name or initial and surname or first middle and last name etc which means I have duplicates when using a pivot table.
Example for all same person
Bob Smith
B. Smith
Bobby Smith
My current fix is to sort alphabetically and drag down against each person with the first available name, then again with next person, so on and on, which takes time with several staff.
Is there a faster way to do this, i.e, either to correct or to lookup against Bob Smith on a master and match and replace as an example?
I have also looked at extracting surname and then doing a lookup with limited results.
Any assistance on fastest way to "cleanse the list" would be appreciated.
thanks in advance