Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-26-2020, 07:49 AM
Johanna Johanna is offline Using find and replace to insert an extra space after full stops Mac OS X Using find and replace to insert an extra space after full stops Office 2019
Novice
Using find and replace to insert an extra space after full stops
 
Join Date: Jun 2019
Location: Bristol
Posts: 28
Johanna is on a distinguished road
Default Using find and replace to insert an extra space after full stops

Hi there,



One of my clients is using the archiac two spaces after a full stop - but she hasn't done this consistently throughout the document.



I've been trying to work out how to use advance F&R to put the extra space in where she's missed them, but I can't get it right. Can anyone help?



I'm using Word for Mac, version 16.34, ie the most up to date version.



Thanks,





Johanna
Reply With Quote
  #2  
Old 02-26-2020, 08:26 AM
Robert2 Robert2 is offline Using find and replace to insert an extra space after full stops Windows 10 Using find and replace to insert an extra space after full stops Office 2007
Competent Performer
 
Join Date: Jun 2013
Posts: 162
Robert2 will become famous soon enoughRobert2 will become famous soon enough
Default

Try doing a wild card Search/Replace operation with:
Find :
^46^32([!^32])
Replace:
^46^32^32\1
Reply With Quote
  #3  
Old 02-26-2020, 08:47 AM
Johanna Johanna is offline Using find and replace to insert an extra space after full stops Mac OS X Using find and replace to insert an extra space after full stops Office 2019
Novice
Using find and replace to insert an extra space after full stops
 
Join Date: Jun 2019
Location: Bristol
Posts: 28
Johanna is on a distinguished road
Default

Thanks Robert - that doesn't work though - it switches the capital letter at the start of the new sentence with the two spaces.



So where the text did read:



nurses. Predicting



it now reads:



nursesP. redicting



And what I need is:



nurses. Predicting (*e2a* the forum seems to remove the extra space from this!)


Any other ideas at all? Thanks!
Reply With Quote
  #4  
Old 02-26-2020, 09:02 AM
Robert2 Robert2 is offline Using find and replace to insert an extra space after full stops Windows 10 Using find and replace to insert an extra space after full stops Office 2007
Competent Performer
 
Join Date: Jun 2013
Posts: 162
Robert2 will become famous soon enoughRobert2 will become famous soon enough
Default

The wild card pattern I gave does work as intended in Word 2007 under Windows 10.
I just tested it with “nurses. Predicting ”.
Maybe things work differently in Word 2019? I doubt it, but it is a possibility.
Are you sure that you used the exact patterns I gave? Did you use copy/paste to enter them?
Reply With Quote
  #5  
Old 02-26-2020, 09:13 AM
kilroyscarnival kilroyscarnival is offline Using find and replace to insert an extra space after full stops Windows 7 64bit Using find and replace to insert an extra space after full stops Office 2010
Expert
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

Quote:
Originally Posted by Johanna View Post

One of my clients is using the archiac two spaces after a full stop - but she hasn't done this consistently throughout the document.

I've been trying to work out how to use advance F&R to put the extra space in where she's missed them, but I can't get it right. Can anyone help?

I'm using Word for Mac, version 16.34, ie the most up to date version.
Hi, Johanna,

Same issue for me here, except I'm not on the newest version but 2010 for Windows. The boss wants double spaces, but most of the newer engineers are haphazard at best about using them.

The best I've been able to do so far is:

1. Find ". " and replace with ". " (replace full stop-single space with full stop-double space): Replace All.

2. Then Find ". " and Replace with ". " (replace full stop-three spaces, for any that were done correctly, with full stop-two spaces): Replace All.

3. Then either eyeball for any double spaces after the stop for, say, the middle initial of someone's name, the stop after Mr, Ms, Inc, etc, or if you were going to write a macro you could add those exceptions and restore them from ". " to ". ".

More often than not, I run the Find/Replace manually, using Find Next to visually look and see if the replace is needed, but this gets tedious in a 20-30 page document.

In my version, under File/Options/Proofing/When correcting spelling and grammar in Word... there is a setting under Grammar to check on spaces required between sentences. You can default it to 1 or 2.

--Ann
Reply With Quote
  #6  
Old 02-26-2020, 09:26 AM
Johanna Johanna is offline Using find and replace to insert an extra space after full stops Mac OS X Using find and replace to insert an extra space after full stops Office 2019
Novice
Using find and replace to insert an extra space after full stops
 
Join Date: Jun 2019
Location: Bristol
Posts: 28
Johanna is on a distinguished road
Default

Quote:
Originally Posted by Robert2 View Post
The wild card pattern I gave does work as intended in Word 2007 under Windows 10.
I just tested it with “nurses. Predicting ”.
Maybe things work differently in Word 2019? I doubt it, but it is a possibility.
Are you sure that you used the exact patterns I gave? Did you use copy/paste to enter them?



I did indeed copy and paste. Strange! Perhaps it is a change between Word versions, although, as you say, this seems unlikely.
Reply With Quote
  #7  
Old 02-26-2020, 09:28 AM
Johanna Johanna is offline Using find and replace to insert an extra space after full stops Mac OS X Using find and replace to insert an extra space after full stops Office 2019
Novice
Using find and replace to insert an extra space after full stops
 
Join Date: Jun 2019
Location: Bristol
Posts: 28
Johanna is on a distinguished road
Default

Thanks Ann, I'll try that!



Quote:
Originally Posted by kilroyscarnival View Post
In my version, under File/Options/Proofing/When correcting spelling and grammar in Word... there is a setting under Grammar to check on spaces required between sentences. You can default it to 1 or 2.

--Ann

That's really helpful - I think I did used to know that, but forgot. So thanks for reminding me.
Reply With Quote
  #8  
Old 02-26-2020, 09:42 AM
Johanna Johanna is offline Using find and replace to insert an extra space after full stops Mac OS X Using find and replace to insert an extra space after full stops Office 2019
Novice
Using find and replace to insert an extra space after full stops
 
Join Date: Jun 2019
Location: Bristol
Posts: 28
Johanna is on a distinguished road
Default

Sadly Ann's method doesn't work either - just searching for a full stop followed by a single space finds all the full stops followed by double spaces, as they are technically followed by a single space - and then another single space!



Any other ideas?
Reply With Quote
  #9  
Old 02-26-2020, 11:25 AM
Robert2 Robert2 is offline Using find and replace to insert an extra space after full stops Windows 10 Using find and replace to insert an extra space after full stops Office 2007
Competent Performer
 
Join Date: Jun 2013
Posts: 162
Robert2 will become famous soon enoughRobert2 will become famous soon enough
Default

The wild card Find pattern that I suggested means “search for a period character followed by a space character, itself followed by any character that is not a space character”. This should normally rule out double space characters.
Maybe your period characters or your space characters are special and don’t correspond to HTML entities ^46 and ^32.
Could you post a short sample document illustrating this problem?
Reply With Quote
  #10  
Old 02-26-2020, 04:18 PM
macropod's Avatar
macropod macropod is offline Using find and replace to insert an extra space after full stops Windows 7 64bit Using find and replace to insert an extra space after full stops 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

The archaic 'two spaces' after sentences rule belongs to the days of typewriters and fixed-width fonts. It has no place in documents using proportional fonts and/or justification.

Moreover, the process discussed above doesn't limit itself to periods at the end of sentences - it also affects every abbreviation that ends with a period. Far simpler is the deletion of those quite unnecessary spaces.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #11  
Old 02-28-2020, 02:11 AM
eNGiNe eNGiNe is offline Using find and replace to insert an extra space after full stops Windows 7 32bit Using find and replace to insert an extra space after full stops Office 2010 64bit
Expert
 
Join Date: Jan 2012
Location: Brussels [BE]
Posts: 746
eNGiNe is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
The archaic 'two spaces' after sentences rule belongs to the days of typewriters and fixed-width fonts.
Quite so! How to apply them consistently may be an interesting brain-teaser, but shouldn't really be a "need to fix this" question these days.
Reply With Quote
  #12  
Old 02-28-2020, 02:31 AM
Johanna Johanna is offline Using find and replace to insert an extra space after full stops Mac OS X Using find and replace to insert an extra space after full stops Office 2019
Novice
Using find and replace to insert an extra space after full stops
 
Join Date: Jun 2019
Location: Bristol
Posts: 28
Johanna is on a distinguished road
Default

I agree, but it's what the client wants.



Does anyone have another solution? I've managed to switch on the 'check two spaces after full stop' button, as per Ann's suggestion, but that only works intermittently, unfortunately.
Reply With Quote
  #13  
Old 02-28-2020, 03:20 AM
macropod's Avatar
macropod macropod is offline Using find and replace to insert an extra space after full stops Windows 7 64bit Using find and replace to insert an extra space after full stops 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

There is no simple programming solution for this. Although VBA has a 'sentences' collection, that has no correlation with grammatical sentences. For example, consider the following:
Mr. Smith spent $1,234.56 at Dr. John's Grocery Store, to buy: 10.25kg of potatoes; 10kg of avocados; and 15.1kg of Mrs. Green's Mt. Pleasant macadamia nuts.
For you and me, that would count as one sentence; for VBA it counts as 5 sentences.

You might be able to use Greg Maxey's 'Sentence Deducer' Addin (Deduced Sentences) to help work out where grammatical sentences end. See also his code in: https://www.msofficeforums.com/97131-post14.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #14  
Old 02-28-2020, 07:07 AM
Johanna Johanna is offline Using find and replace to insert an extra space after full stops Mac OS X Using find and replace to insert an extra space after full stops Office 2019
Novice
Using find and replace to insert an extra space after full stops
 
Join Date: Jun 2019
Location: Bristol
Posts: 28
Johanna is on a distinguished road
Default

Ok, thanks Paul. I feel a bit less dense that there isn't an easy answer! For now I'll just keep eyeballing them I guess!
Reply With Quote
  #15  
Old 02-28-2020, 08:17 AM
Charles Kenyon Charles Kenyon is offline Using find and replace to insert an extra space after full stops Windows 10 Using find and replace to insert an extra space after full stops Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,083
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

For a manual solution, in Replace, find .[space] and Replace with .[space][space] and do not hit Replace All. Rather find the first and use the Replace button to go through a document one at a time. Still likely to to be quicker and easier than just going through the document by eyeball.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro for Find/replace to remove space before Hard Return AlfredStreich Word VBA 4 01-23-2020 03:59 PM
Using find and replace to insert an extra space after full stops Code to find numerical string + space throughout document & replace them with Comma Robert Kay Word VBA 6 02-21-2018 04:41 PM
Using find and replace to insert an extra space after full stops Find and Replace with space cheech1981 Word 3 03-29-2017 02:33 PM
Mac 2011 Word find/replace stops working jondic Word 0 08-31-2016 02:58 AM
Wildcard Find/Replace deletes extra character Cosmo Word 1 06-20-2014 08:49 AM

Other Forums: Access Forums

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