Thread: regEx replace
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default regEx replace
Hi again,

Am Thu, 2 Apr 2015 10:26:21 -0700 schrieb Robert Crandal:

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

try it with

ptrn = "[\d-\d-\d]"


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
Reply With QuoteReply With Quote