View Single Post
  #4   Report Post  
Herb Tyson [MVP]
 
Posts: n/a
Default

If there are more than two spaces between words, it could be done in one
fell swoop using a wildcard specification. For example, with Use Wildcards
checked, assuming no more than 10 [accidental] spaces:

Find what: {2,10} i.e., space{2,10}, which means find 2 to 10 spaces

Replace with: space, which means replace the find what with a
single space

There's no reason to limit it to 10, but I would think it unlikely that
you'd have more than 10 spaces -- accidentally -- between words. As a
practical matter, it might never be more than 3 or 4.


--
Herb Tyson MS MVP
Please respond in the newsgroups so everyone can follow along.
http://www.herbtyson.com
"GKW in GA" wrote in message
...
Wouldn't you have to do it multiple times until you didn't find 2 adjacent
spaces. Lets say you had 3 spaces between words (accidently, of course),
scanning and replacing 1 time would leave you with 2 spaces where there
were
3 or 3 spaces were there were 4, etc. until you didn't find 2 adjacent
spaces
anymore.

"Herb Tyson [MVP]" wrote:

You can use Find/Replace. Assuming you never want two spaces to occur,
you
can change " " to " " (the first is two spaces, the second is a single
space), and tell the Replace dialog to Replace All.

If there are times when you'd like two spaces, then you'd have to work
out
the circumstances, and it's possible that a Wildcard Find/Replace could
do
the job.

--
Herb Tyson MS MVP
Please respond in the newsgroups so everyone can follow along.
http://www.herbtyson.com
"GKW in GA" wrote in message
...
Is there a way to remove extra spaces between words so there is only
one
space between them