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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top