Space removal - a first name,space last name

  • Thread starter Thread starter Tech Express
  • Start date Start date
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
 
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.
 
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
 

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

Similar Threads

modifying name format within a cell 2
Pesky spaces 1
Editing Text 4
Matching Names 5
splitting Last Name, First Name 4
Formatting in formulas not allowed before commas 5
Extract text in middle using Mid and Find or Search 5
For Claus From OP: 1

Back
Top