I am trying to remove the salutations from an excel column. The column contains random data. Some names have prefix "Mr.", "Mrs." and some have nothing before the. For example:
Ms. John Doe
Mr. John Doe
What can I do in this case to remove the "Ms." and "Mrs." without affecting the...