Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Luke M;221359 Wrote: 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 Are ther possibly spaces at the start or end of the string ( before Bill and/or after Smith)? -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers *Adding your XL version* to your post helps finding solution faster ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=60994 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 -- If this helps, please click the Yes button Cheers, Shane Devenshire "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 |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Shane, thx for your reminder about the number of columns for Access ( lost the post, sorry) -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers *Adding your XL version* to your post helps finding solution faster ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=60994 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
enter does 1 line space- scanner does 2 line space need 1 line | New Users to Excel | |||
Can I automatically add space after ea. row ("Space After" in Word | Excel Discussion (Misc queries) | |||
formula that will go up one space if no value in specified space | Excel Worksheet Functions | |||
Paper Space / Model Space ? | Excel Discussion (Misc queries) | |||
space | Excel Discussion (Misc queries) |