Hi..
can someone please help me in doing a macro code.. i cant explain it well but ill make an example
In excel file
Column A Column B(For Output)
Dr. Abc Def Abc Def
Dr Ghi Jkl Ghi Jkl
i want to remove all the "Dr" or any special characters(' , "" . ! #*) in a name so that it will result like in a column be.. how can i please do that in excel.. a little help please
|