Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-08-2018, 09:45 AM
doctorduncan doctorduncan is offline Replace Two Spaces with One Space Windows 7 32bit Replace Two Spaces with One Space Office 2007
Advanced Beginner
Replace Two Spaces with One Space
 
Join Date: May 2017
Posts: 48
doctorduncan is on a distinguished road
Default Replace Two Spaces with One Space

I am trying to replace all the occurrences of two spaces between a period and the start of the next sentence into one space. I looked around and in theory, in the Find and Replace dialog and using the "Find What" field, enter a space and then {2,}


Then I want to put one space in the field of what to replace this with. Somehow I haven't gotten this correct because the find command does nothing.

How can I accomplish this? Thanks.
Reply With Quote
  #2  
Old 06-08-2018, 10:04 AM
d4okeefe d4okeefe is offline Replace Two Spaces with One Space Windows 10 Replace Two Spaces with One Space Office 2016
Advanced Beginner
 
Join Date: Apr 2013
Posts: 77
d4okeefe is on a distinguished road
Default

You have to enable "Use Wildcards" for the {2} to work.
Although you may simply want to type two spaces in the Find box, and one space in the Replace box. That usually works for me.
Reply With Quote
  #3  
Old 06-08-2018, 04:44 PM
macropod's Avatar
macropod macropod is offline Replace Two Spaces with One Space Windows 7 64bit Replace Two Spaces with One Space Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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 this with a wildcard Find/Replace, where:
Find = .{2,}
Replace = .^32
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
replace, spaces

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Replace Two Spaces with One Space How to find and replace random empty spaces in beginning of lines? Pauliina Word 4 05-24-2018 10:01 PM
Replace Two Spaces with One Space Macro to find and replace specific types of spaces dita Word VBA 7 05-06-2018 12:47 AM
Replace Two Spaces with One Space Find and Replace/Insert 'CR', delete leading Spaces wherever a user Clicks in a Word document DavidL Word VBA 7 04-04-2018 12:01 AM
Replace Two Spaces with One Space Find and Replace with space cheech1981 Word 3 03-29-2017 02:33 PM
Replace Two Spaces with One Space Find and replace mutiple spaces between lowercase words only Dave T Word VBA 2 07-16-2015 11:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:05 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