Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-27-2015, 07:44 AM
cheech1981 cheech1981 is offline Replacing [A-Z] with actual letter Windows 7 64bit Replacing [A-Z] with actual letter Office 2010 64bit
Advanced Beginner
Replacing [A-Z] with actual letter
 
Join Date: Nov 2011
Location: New Jersey, USA
Posts: 77
cheech1981 is on a distinguished road
Default Replacing [A-Z] with actual letter

Hi everyone,



I am curious about a find and replace in Word 2013.

I am searching for all instances of a period followed by one space and a capital letter, as follows (without the quotes, and wildcards are turned on): ". [A-Z]"

Is it possible to replace this query with a period followed by two spaces, followed by the actual letter that the search finds for every instance (so of course that letter will vary)?

Any ideas are welcome, thank you in advance!
Reply With Quote
  #2  
Old 03-27-2015, 07:52 AM
gmayor's Avatar
gmayor gmayor is offline Replacing [A-Z] with actual letter Windows 7 64bit Replacing [A-Z] with actual letter Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,103
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Search for
(. )([A-Z])
Replace with
\1 \2

See http://www.gmayor.com/replace_using_wildcards.htm
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 03-27-2015, 07:59 AM
cheech1981 cheech1981 is offline Replacing [A-Z] with actual letter Windows 7 64bit Replacing [A-Z] with actual letter Office 2010 64bit
Advanced Beginner
Replacing [A-Z] with actual letter
 
Join Date: Nov 2011
Location: New Jersey, USA
Posts: 77
cheech1981 is on a distinguished road
Default

Awesome! Thanks!
Reply With Quote
  #4  
Old 03-29-2015, 11:13 PM
eNGiNe eNGiNe is offline Replacing [A-Z] with actual letter Windows 7 32bit Replacing [A-Z] with actual letter Office 2010 64bit
Expert
 
Join Date: Jan 2012
Location: Brussels [BE]
Posts: 746
eNGiNe is on a distinguished road
Default

Quote:
Originally Posted by cheech1981 View Post
Is it possible to replace this query with a period followed by two spaces
fwiw … Pretty well every time I've seen it mentioned, the idea of "full stop followed by two spaces" has been condemned as a left-over from typewriters :-}
Reply With Quote
  #5  
Old 03-30-2015, 02:20 AM
gmayor's Avatar
gmayor gmayor is offline Replacing [A-Z] with actual letter Windows 7 64bit Replacing [A-Z] with actual letter Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,103
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Indeed it is, but there are still organisations that have not woken up to the era of word processing and proportionally spaced fonts
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #6  
Old 03-30-2015, 05:33 AM
BruceM BruceM is offline Replacing [A-Z] with actual letter Windows 7 64bit Replacing [A-Z] with actual letter Office 2010 32bit
Advanced Beginner
 
Join Date: Feb 2015
Posts: 41
BruceM is on a distinguished road
Default

My take on two spaces at the end of a sentence is that it tends to make it more readable, particularly in text that contains names and other capitalized words, or if the text contains abbreviations. I find that the doubled space creates a clear visual break between sentences in a way a period alone does not, no matter the font. I suppose it does depend somewhat on the font.
Reply With Quote
  #7  
Old 03-30-2015, 07:12 AM
Charles Kenyon Charles Kenyon is offline Replacing [A-Z] with actual letter Windows 7 64bit Replacing [A-Z] with actual letter Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,138
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

Bruce, for a fuller exploration of the two-space question, I would refer you to an older (very short) book: The Mac is Not a Typewriter, 2nd Edition, by Robin Williams.
and
Why you should use one space after each sentence

Last edited by Charles Kenyon; 08-15-2020 at 10:37 PM.
Reply With Quote
  #8  
Old 03-30-2015, 08:51 AM
BruceM BruceM is offline Replacing [A-Z] with actual letter Windows 7 64bit Replacing [A-Z] with actual letter Office 2010 32bit
Advanced Beginner
 
Join Date: Feb 2015
Posts: 41
BruceM is on a distinguished road
Default

I can do whatever the situation requires, but in this context I was merely expressing a personal preference. I realize it is a minority view.
Reply With Quote
  #9  
Old 03-30-2015, 11:12 PM
eNGiNe eNGiNe is offline Replacing [A-Z] with actual letter Windows 7 32bit Replacing [A-Z] with actual letter Office 2010 64bit
Expert
 
Join Date: Jan 2012
Location: Brussels [BE]
Posts: 746
eNGiNe is on a distinguished road
Default

Quote:
One of the most popular Macintosh books ever written, The Mac is not a typewriter (Robin Williams; Berkeley, Peachpit Press, 1990) 'covers the top twenty things you need to know to make your documents look clean and professional' and has been called the 'Strunk and White of typography.'
Yup, that's where I first came across the idea … after cutting my teeth on mainframe publishing programs that ran off plain text files with an 80-character line length and would have ruthlessly deleted any spaces they didn't agree with anyway. Happy days :-}
Reply With Quote
  #10  
Old 05-27-2015, 05:11 PM
cheech1981 cheech1981 is offline Replacing [A-Z] with actual letter Windows 7 64bit Replacing [A-Z] with actual letter Office 2010 64bit
Advanced Beginner
Replacing [A-Z] with actual letter
 
Join Date: Nov 2011
Location: New Jersey, USA
Posts: 77
cheech1981 is on a distinguished road
Default

I agree with using only one space. Unfortunately, APA 6 has gone back to recommending two spaces for copy manuscripts to aid readability for readers who have to read a lot of draft text throughout the day (given that the APA manual is geared toward copy manuscripts).

To make matters worse, many organizations, schools, etc., misinterpret this recommendation and apply it to final manuscripts, which forces editors and formatters to ensure two spaces after end-of-sentence punctuation. So the find and replace above is quite helpful. Note that you should first find " ^w" and replace with " " without the quotes so that you are starting with a period with one space after each sentence (given that some users have entered 3 or more spaces after sentences), then run the replace all given by gmayor above.

Last edited by cheech1981; 05-27-2015 at 11:33 PM.
Reply With Quote
  #11  
Old 08-15-2020, 08:44 PM
cheech1981 cheech1981 is offline Replacing [A-Z] with actual letter Windows 10 Replacing [A-Z] with actual letter Office 2016
Advanced Beginner
Replacing [A-Z] with actual letter
 
Join Date: Nov 2011
Location: New Jersey, USA
Posts: 77
cheech1981 is on a distinguished road
Default

Update. APA came to their senses in the 7th ed., reverting to one space after punctuation unless the publisher asks otherwise.
Reply With Quote
  #12  
Old 08-15-2020, 10:34 PM
Charles Kenyon Charles Kenyon is offline Replacing [A-Z] with actual letter Windows 10 Replacing [A-Z] with actual letter Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,138
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

With proportionally spaced text two spaces makes it harder to read and ugly, IMO.
Reply With Quote
Reply

Tags
find and replace, wildcards, [a-z]



Similar Threads
Thread Thread Starter Forum Replies Last Post
Replacing [A-Z] with actual letter Replacing Timestamps Madcat Word 1 08-23-2014 09:09 PM
Letter date changes when merging with Excel - not the format, the actual date! Smallweed Mail Merge 1 02-07-2014 06:00 PM
Replacing texts aslamyahya Excel Programming 1 02-27-2013 10:38 PM
Replacing [A-Z] with actual letter Word replacing problem!!!! Jamal NUMAN Word 2 07-08-2011 03:56 AM
MS Project able to import actual start and or actual finish date from Excel? mhacker Project 0 04-26-2010 11:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:44 PM.


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