Word 2K Find and Replace w/wildcard

[crjo]

I have about 10 pages of text that looks something like this: 9/12/2003,1098,9/15/2003,3421,10/1/2003,7856 etc.

I would like to replace the comma between the last digit of the number and the first digit of the date with a carriage return. Can I do this with a wildcard string?

 

[SkipVought]

Hi,

You could do a Replace 12 times of

,1/

with

^p1/

then chage 1 to 2 up to 12

OR run this macro

Sub ReplA()
    For i = 1 To 12
        Selection.Find.ClearFormatting
        Selection.Find.Replacement.ClearFormatting
        With Selection.Find
            .Text = "," & i & "/"
            .Replacement.Text = "^p" & i & "/"
            .Forward = True
            .Wrap = wdFindContinue
            .Format = False
            .MatchCase = False
            .MatchWholeWord = False
            .MatchWildcards = False
            .MatchSoundsLike = False
            .MatchAllWordForms = False
        End With
        Selection.Find.Execute Replace:=wdReplaceAll
    Next
End Sub

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[crjo]

Went with the macro. Thanks Skip!