Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-01-2023, 04:21 AM
paulkaye paulkaye is offline Find-replace macro - I got stuck! Windows 10 Find-replace macro - I got stuck! Office 2016
Advanced Beginner
Find-replace macro - I got stuck!
 
Join Date: Nov 2011
Posts: 84
paulkaye is on a distinguished road
Default Find-replace macro - I got stuck!

Hi all,
I've tried my best to convert the find-replace knowledge that I've learned from here into a macro, but I just can't get it right. I'm trying to build a macro that will convert all instances of:

.{tab}The {text} according to any one of examples {lownum}-{highnum},

into

.{tab}The {text} according to example {lownum},

In the above:
{tab} represent a tab character (e.g. ^t).


{text} can be any text and should remain as-is. If it is difficult to achieve this without unpredictable results, then it would be ok for this to be a single word.
{lownum}-{highnum} represents a range. Their absolute and relative values are unimportant. The number before the hyphen (i.e. {lownum}) should remain as-is, while the hyphen and the number following the hyphen (i.e. {highnum}) should be deleted.
Reply With Quote
 

Tags
find & replace



Similar Threads
Thread Thread Starter Forum Replies Last Post
Find and Replace Macro Need djpemberton Word VBA 2 05-04-2016 07:53 PM
Find-replace macro - I got stuck! Find and Replace Macro amparete13 PowerPoint 3 03-11-2014 05:29 AM
Find-replace macro - I got stuck! Is the following too complex for find/replace macro? bertietheblue Word VBA 12 11-04-2013 05:35 PM
macro or find/replace JamesVenhaus Word 2 02-27-2012 03:34 PM
Find and Replace Macro - A Better Way Tribos Word VBA 0 10-08-2008 03:22 AM

Other Forums: Access Forums

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