I have a huge database which i usually convert to excel file.

here is the problem now. For the names, i have a column lets say b

MR Rais Azad
Dr Rais Azad
MS Sophie
MISS Sophie

I have a set of title and Academic title in German.
---------------
Frl.
Ing.
Frau
Dipl. Ing.
Herr
Dipl.-Kfm.
Familie
Mag.
Dr.
Dres.
Priv. Doz.
Prof.
Gräfin
Graf
---------------

I want to have a function which can, first find and match the above titles and if match- move them to the col A

Giving me something like this:

MR Rais Azad
Dr Rais Azad
MS Sophie
MISS Sophie

Please let me know if there is something which can help me to fix this.

Thank You