Thread: regEx replace
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal[_3_] Robert Crandal[_3_] is offline
external usenet poster
 
Posts: 161
Default regEx replace

"Claus Busch" wrote:

\d is equivalent to [0-9]
To find parentheses you have to put a back slash in front
\( and \)
But I am not an expert with Regulkar Expressions. I always play around
with try and error.


Yup, I'm not a regular expression expert either. For the pattern,
my guess was: "\(\d\d\d\)\d\d\d-\d\d\d\d"

The only problem was that the entire string got replaced with
a single "*", instead of filling in all 13 characters with a "*".