how do I replace string 123-4 with 123 4

davidjm · #14 10-31-2021, 04:51 PM

Hi,
working on this I've replaced

Code:

    .Text = "[0-9]{3}–[0-9]{1}"

with

Code:

     .Text = "[0-9]{2,3}–[0-9]{1,2}"

Which produces better results for references that span more than 1 page and keeps original format.

Was thinking if I just add 2 to any numeric string ("[0-9]{2,3}") regardless of if it was part of a range or an individual page number that would reduce the whole process to 1 .find . Is that correct? What would be the script
Thanks for any help

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Replace characters in a string	Marcia	Excel Programming	5	05-04-2020 05:15 AM
Wildcard replace any string in context with a specified string	wardw	Word	7	05-07-2018 09:13 AM
Replace multiple strings by one same string at once	puff	Word	2	02-28-2018 11:04 AM
Replace characters in a string	Anthon	Excel Programming	1	11-03-2016 12:48 AM
How to do multiple find and replace in string.	PRA007	Word VBA	2	01-06-2016 09:10 PM