An Excel Spreadsheet is set up like this with hundreds of duplicate names and
addresses:

Name Address City Zip
Etc.
Smith, Joe 10 S. Oak
Smith, Mary 10 S. Oak

QUESTIONS:
1: How do I eliminate the comma and everything to the right of the comma for
all records, i.e. ,Joe and , Mary.
2: How do I eliminate duplicate addresses.
My goal is to have one entry as follows:
Name Address
Smith 10 S. Oak
And eliminate duplicate addresses and first name leaving only one last name
to each address. Can it be done?