Finding certain word in cell....then split text

Hello!

As you can see I'm new here and I hope I wont do anything wrong posting this thread.

So my problem is like this.
In column A, I have names, surnames, middlename (if there is) and also in some cases some other informations, like S.P., D.O.O.,MAG.,DR.,....(I will call it "other info")
First of all I want to delete that "other info" (S.P.,D.O.O,...) from every cell where it is written. If it is possbile I would like to have these "other info" written in sheet2 and program would lookup if lets say cells A1:A100 have any of these "other info" in it and if there is it would delete it (not the whole cell, just "other info"). Why written in sheet2 - because if I realize that there is some new word I dont need it, i will simply add it onto the list.
When this is done, I would like so separate names and surnames, (middlenames) each in own column.
I know for find and replace and also for text to columns, but I would like to have a code in macro, so I could do that with a simple selection and click.

Any thoughts?

Thanks for all answers in advance and sorry if my Englih is not the best.

Sencirely, Tilen