Thread: regEx replace
View Single Post
  #9   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:

can you post an example of Social Security numbers?
I don't know how they look like in your country.


In my country, they are typically 123-45-6789.

So, my guess for the pattern would be:

regEx.Pattern = "\d\d\d-\d\d-\d\d\d\d"