I have an Excel spreadsheet with a Contact column that has the contact's full name and title, like this: John Q. Doe, Director of Marketing.
I need three new columns created with the data from this column: a First Name column, a Last Name column, and a Title column. So in the case of this row, the First Name = John, the Last Name = Doe, and the Title = Director of Marketing.
Notice that (1) any middle initials and the periods after middle initials are eliminated, (2) the comma after the last name is eliminated, (3) if commas or periods occur in the title, they should not be eliminated, and (4) in the newly created fields, there should be no spaces after the data.
There are 725 rows in the spreadsheet.
====== Hello halsegal, will do it right now. Please check PMB. Thanks. ======