![]() |
|
#1
|
|||
|
|||
![]() Thanks, Guessed! The more we know, the better! And thanks to RobiNew for another challenge! Last edited by vivka; 10-21-2023 at 10:21 AM. |
#2
|
|||
|
|||
![]()
Sorry, but I'm here again. The code variant here below changes '95 to '9. Why? Thanks!
Code:
Sub SingleBeforeDigit() 'Replace Chr(145) with Chr(146) before a digit (as in ’95) Dim oRng As Range Set oRng = ActiveDocument.Range Options.AutoFormatAsYouTypeReplaceQuotes = False With oRng.Find .ClearFormatting .Text = Chr(145) & "([0-9])" & "[!^02]" 'to avoid footnote ref. marks .Replacement.Text = Chr(146) & "\1" .Forward = True .Wrap = wdFindContinue .MatchWildcards = True .Execute Replace:=wdReplaceAll End With Options.AutoFormatAsYouTypeReplaceQuotes = True End Sub |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
lalywizz | Word | 5 | 10-08-2021 09:27 AM |
![]() |
arkansawyer16 | Excel | 10 | 04-06-2020 02:03 PM |
Regex/wildcard search for dates with 2-digit and 4-digit years | Marrick13 | Word VBA | 2 | 01-29-2016 07:04 AM |
![]() |
laucn | Excel Programming | 14 | 05-17-2015 12:12 PM |
![]() |
Natalie | Word | 2 | 04-26-2012 05:17 AM |