Assume there is a list of names appearing in range A2:A9. Before these names, there are abbreviations such as Dr., Mr. Mrs. etc. To worsen the situation, there may/may not be a space after the abbreviation. A sample dataset may look like this:
Dr (Mrs.) Indu Sharma
Dr. (Mr) Rakesh Singh
Mr. Mrinal Joshi
The task is to extract only the names in another column.
You may refer to my solution in this workbook.