Thread: Change characters outside a wildcard while keeping wildcard results
View Single Post
 
Old 04-09-2014, 10:49 AM
nymusicman nymusicman is offline Windows 8 Office 2007
Novice
  
Join Date: Apr 2014
Posts: 2
nymusicman is on a distinguished road
Default Change characters outside a wildcard while keeping wildcard results
What I want to do:

Find a comma in front of a number ",1" and change it to a period ".1"

How I'm currently doing it

Code:
With Selection.Find
.Text = ",1"
.Replacement.Text = ".1"
...
and repeat for all numbers 0-9.

I'd like to condense this maybe using something like
Code:
.Text = ",[0-9]"
But I'm not sure how to go about it.

Please help!
Reply With Quote