Macro code to display qualification in next column-reg

Good Morning Sir

Kindly help me for a macro code for the following scenario

I have list of Doctors name with qualification in Column A

I want a macro code which will remove the qualification from Column A and display it in Column B

For example Dr SSSS MBBS MD is in Column A

The output should be Dr SSSS in column A and MBBS MD in Column B

i have attached excel file for your reference

thanks

Dear Sir,

Thanks for your response

I have tested the program.

The qualification of doctor in column A is not getting removed.

Eg In column A Dr RRRR MBBBS,MD

The output should be Column A Dr RRRR Column B MBBS MD

If i give qualification as input, it should search in Column A and remove and replace the qualification in Column B



Thanks i