Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-09-2025, 11:44 PM
WJSwanepoel WJSwanepoel is offline Picking up trailing space before quotation mark Windows 10 Picking up trailing space before quotation mark Office 2021
Advanced Beginner
Picking up trailing space before quotation mark
 
Join Date: Dec 2019
Location: Krugersdorp, South Africa
Posts: 82
WJSwanepoel is on a distinguished road
Question Picking up trailing space before quotation mark

I have document where the closing quotation mark is preceded by a space. I need to remove that space. However I cannot search for a space followed by the quotation mark and do a global replace, because the opening quotation mark is always preceded by a space.

How can I do the correction using wildcard search and replace?

The document contains too many of these to make manual replacements feasible.

Example:
This is simply a "political agenda ".


Must become:
This is simply a "political agenda".

I also need to mention that the "closing" quotation mark is actually an "opening" quotation mark i.e. a ^0147 rather than a ^0148.
This is simply a ^0147political agenda ^0147.
Must become:
This is simply a ^0147political agenda^0148.

Last edited by WJSwanepoel; 02-10-2025 at 12:05 AM. Reason: To give more clarity
Reply With Quote
 

Tags
quotation mark, replace, wildcard



Similar Threads
Thread Thread Starter Forum Replies Last Post
Find and replace paragraph mark on selected text and replace it with space in PowerPoint VBA laith93 PowerPoint 0 11-09-2023 04:34 AM
Trim trailing space macro stopped working jec1 Word VBA 2 08-01-2021 11:32 PM
Picking up trailing space before quotation mark Replace space with paragraph mark jeffreybrown Word VBA 8 08-22-2018 03:31 PM
Picking up trailing space before quotation mark Em dash and closing curly quotation mark lexsper Word 3 04-07-2015 07:12 AM
Can't find space before closing quotation marks wardw Word 7 01-16-2014 12:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:48 PM.


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