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
Bookmarks