Thread: how do I replace string 123-4 with 123 4
View Single Post
 
Old 11-03-2021, 01:00 AM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
  
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,161
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
Why do you need to? The macro above that searches for
.Text = " [0-9]{2,3}"
will find all 2 or 3 digit numbers preceded by a space (which is all of the numbers other than the ones preceded by a dash.

I'm not sure why you specifically excluded the first nine pages from that search though. Is there no index entries on those pages?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote