Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-16-2015, 01:28 AM
Dave T Dave T is offline Find and replace mutiple spaces between lowercase words only Windows 7 64bit Find and replace mutiple spaces between lowercase words only Office 2007
Advanced Beginner
Find and replace mutiple spaces between lowercase words only
 
Join Date: Nov 2014
Location: Australia
Posts: 66
Dave T is on a distinguished road
Default Find and replace mutiple spaces between lowercase words only

Hello All,

I have been trying to find the wildcards parameters to search for any number of multiple spaces between lowercase words only.



For example 'The quick brown fox jumps over'. Which with the spaces represented by <space> would be 'The quick<space><space><space>brown<space><space><spac e><space>fox jumps<space><space>over'.

I have found various Find and Replace macros that use a variety of wildcard choices i.e. ([ ])[ ]{1,} works, but it replaces any number of multiple spaces anywhere within the document with a single space. Any number of extra spaces at the beginning of a paragraph get replaced by a single space (would be best to have none but I can find this via another Find and Replace).

Any number of spaces between lowercase words are replaced by a single space - this is what I want (this is all I want it to find and replace). Any extra spaces at the end of a sentence are replaced by a single space (I am not getting into the two spaces after a full stop debate).

Any suggestions appreciated.

Regards,
Dave T
Reply With Quote
  #2  
Old 07-16-2015, 01:51 AM
macropod's Avatar
macropod macropod is offline Find and replace mutiple spaces between lowercase words only Windows 7 64bit Find and replace mutiple spaces between lowercase words only Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You can do that with a wildcard Find/Replace, where:
Find = ([a-z])[ ]{2,}([a-z])
Replace = \1 \2
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 07-16-2015, 11:23 PM
Dave T Dave T is offline Find and replace mutiple spaces between lowercase words only Windows 7 64bit Find and replace mutiple spaces between lowercase words only Office 2007
Advanced Beginner
Find and replace mutiple spaces between lowercase words only
 
Join Date: Nov 2014
Location: Australia
Posts: 66
Dave T is on a distinguished road
Default

Thanks Paul,

Works very well now.

Regards,
Dave
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Find and replace mutiple spaces between lowercase words only Spaces between words, help! cheffie Word 2 10-02-2013 01:59 PM
Find and replace mutiple spaces between lowercase words only Find & Replace: substitute red-coloured words with underscores tinfanide Word 2 10-06-2012 11:04 PM
find&replace word in uppercase with word in lowercase andrei Word 3 10-03-2011 05:11 AM
Find and replace mutiple spaces between lowercase words only Is there a way to use "find/replace" to find italics words? slayda Word 3 09-14-2011 02:16 PM
Find and replace mutiple spaces between lowercase words only Find & Replace words with "/" prefix & suffix tollanarama Word 4 01-25-2011 02:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:02 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft