![]() |
|
#8
|
|||
|
|||
|
Hi Andrew,
Thanks very much for taking the time to do this, much appreciated. Huge advance and I've learned alot more from this than Googling in the dark. I've noticed there's a mixture of formats for page ranges as you can see from below: Before .................................................. ........ After average variable (AVC) 108, 305 < > average variable (AVC) 108, 305 external 41–3, 164–5, 175, 186–8 < > external 41–3, 166-7, 175, 188-10 long run 113–14 < > long run 115-34 marginal (MC) 105–6, 110 < > marginal (MC) 107-8, 110 private 41–2, 186 < > private 41–2, 186 short run 106–9 < > short run 108-11 social 186–7 < > social 188-9 credit 16, 205, 206, 215, 258–61, 308 < > credit 16, 205, 206, 215, 260-81, 308 If there's for example 186-8 then After should be 188-0 (to keep the current format) I have another question, your code includes Code:
.Text = "[0-9]{3}–[0-9]{1}"
Thanks for all your help |
|
|
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 |