Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-29-2018, 10:22 AM
dita dita is offline Macro to find and replace specific types of spaces Windows XP Macro to find and replace specific types of spaces Office 2010 64bit
Advanced Beginner
Macro to find and replace specific types of spaces
 
Join Date: Apr 2018
Posts: 34
dita is on a distinguished road
Default Macro to find and replace specific types of spaces

Hello,



This one looks a bit tricky but hope any of you guys know how to do it!

I need a Macro to make a multiple search of different types of spaces which appears along to numbers or symbols.

The idea is that the Macro FIND some specific types of spaces and THEN replace them with non-breaking spaces.

When the Macro finds such spaces, I will decide if the space can be replaced by a non-breaking space or not. So, the Macro should prompt and ask if the space can be replaced by a non-breaking space and then continuing with the rest of instances.

Basically, the Macro will search the following spaces:

NOTE: I have put an asterisk "*" in order to make visible the space

- All numbers following a space: [0‐9]*
- Equal sign and space: =*
- Space and equal sign: *=
- Bracket followed by space: [0‐9]\)

Would that be possible?

Thanks in advance!
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to find and replace specific types of spaces 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
Find and Replace Macro Need djpemberton Word VBA 2 05-04-2016 07:53 PM
Macro to find and replace specific types of spaces Find and replace mutiple spaces between lowercase words only Dave T Word VBA 2 07-16-2015 11:23 PM
Macro to find and replace specific types of spaces Find and Replace Macro amparete13 PowerPoint 3 03-11-2014 05:29 AM
Macro to find and replace specific types of spaces Macro to replace one specific heading style with another ubns Word VBA 44 09-04-2012 08:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:25 AM.


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