Space removal - a first name,space last name

[Tech Express]

How can I remove the space after the comma but not all the spaces?
Or enforce the rule - when a comma is used there will be one space and only
one space after the comma?

I have names on the database:
Bill, Smith
Bill,Smith

I need one or the other for unique names being serviced.

Thx

 

[Luke M]

You could just do a find & replace (Ctrl+H) and search for ", " and replace
with ","
To limit your search, if needed, select only the area you want to
replacements to occur before running.

 

[Shane Devenshire]

Hi,

Assume that you can have any number of spaces then the solution would be to
use TRIM

If A1 contains the name use =TRIM(A1)

copy as needed and convert to values, get rid of the originals