Change characters outside a wildcard while keeping wildcard results

nymusicman · #1 04-09-2014, 10:49 AM

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!

macropod · #2 04-09-2014, 03:53 PM

Try:

.Text = ,([0-9])
.Replacement.Text = .\1
.MatchWildcards = True

nymusicman · #3 04-10-2014, 08:17 AM

Thank you, that worked. I was just missing paranthesis and the wildcard true statement.

Facepalm moment!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Tricky wildcard search	NobodysPerfect	Word	10	03-19-2014 04:29 AM
Wildcard for selective deleting	binar	Word	1	01-10-2013 04:37 AM
Wildcard Problem with Emailadresses	Fmax	Word	1	06-17-2010 06:09 AM
Wildcard search help.	Kempston	Word	0	11-13-2009 03:58 AM
Extract from String using Wildcard	whousedmy	Word	0	05-21-2009 01:35 AM