How to remove Comma In name fornat

  • Thread starter Thread starter amy
  • Start date Start date
A

amy

Need your help urgently.

I have the following name format:

Lee,Siew Lin and Aminah Binti,Ali

How to remove the comma and became the name format as
Lee Siew Lin and Aminah Binti Ali.

Your help is deeply appreciated.
 
Select your range and then...

Edit|replace
what: , (comma)
with: (spacebar)
replace all
 
Back
Top