View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default Space removal - a first name,space last name

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.
--
Best Regards,

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


"Tech Express" wrote:

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

--
Russ at scaninc.org