Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-21-2019, 06:06 AM
Johanna Johanna is offline Find and replace query re missing spaces Mac OS X Find and replace query re missing spaces Office 2019
Novice
Find and replace query re missing spaces
 
Join Date: Jun 2019
Location: Bristol
Posts: 28
Johanna is on a distinguished road
Default Find and replace query re missing spaces

Hi Word fans,





I'm editing a piece in which the client has sporadically and randomly missed the space between a full stop and the next letter.



I'm trying to use find and replace to correct this.



I have got as far as working out that inserting this in the find box locates all examples of this:



. ^$


However, I can't work out what to put into Replace to keep the full stop and the first letter of the new sentence but insert a space.



Can anyone help?



Thanks!



H
Reply With Quote
  #2  
Old 11-21-2019, 03:06 PM
Guessed's Avatar
Guessed Guessed is offline Find and replace query re missing spaces Windows 10 Find and replace query re missing spaces Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Wildcards on
Find: ".([A-Z]{1})"
Replace: ". \1"

Without the double quotes
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 11-21-2019, 08:06 PM
macropod's Avatar
macropod macropod is offline Find and replace query re missing spaces Windows 7 64bit Find and replace query re missing spaces 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

Presumably they've done the same with other sentence endings, too. In which case you could try a wildcard Find/Replace, where:
Find = ([.\!\?])([A-Z])
Replace = \1 \2
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 11-22-2019, 01:06 AM
Johanna Johanna is offline Find and replace query re missing spaces Mac OS X Find and replace query re missing spaces Office 2019
Novice
Find and replace query re missing spaces
 
Join Date: Jun 2019
Location: Bristol
Posts: 28
Johanna is on a distinguished road
Default

Thanks both, really appreciate it.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find and replace query re missing spaces How to find and replace random empty spaces in beginning of lines? Pauliina Word 4 05-24-2018 10:01 PM
Find and replace query re missing spaces Macro to find and replace specific types of spaces dita Word VBA 7 05-06-2018 12:47 AM
Find and replace query re missing spaces Find and replace mutiple spaces between lowercase words only Dave T Word VBA 2 07-16-2015 11:23 PM
Find and replace query re missing spaces Word Find and Replace Query bthart Word 1 12-29-2011 12:45 AM
Find and replace query re missing spaces Help with find and replace or query and replace shabbaranks Excel 4 03-19-2011 08:38 AM

Other Forums: Access Forums

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