Dear Sir,
i am trying to remove the unknown character and extra space from the name. Though i use formula as trim or proper(trim), it is not removing the Unknown character / extra space. I have attached the few name as sample. can you help me with the formula to remove these Unknown character / extra space, double space, special character from selected cell?
Note : I am using ms office 2013
Thanks & Regards,
Senthil
Bookmarks