How to remove Comma In name fornat

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.
 
D

Dave Peterson

Select your range and then...

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