Space removal - a first name,space last name

T

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
 
L

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

Pecoflyer

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

Luke M
*Remember to click "yes" if this post helped you!*
Click to expand...

Are ther possibly spaces at the start or end of the string ( befor
Bill and/or after Smith)

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste
 
S

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
 
P

Pecoflyer

Shane, thx for your reminder about the number of columns for Access
lost the post, sorry

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste
 
Top