Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
"Robert Crandal" wrote:
'-------------------------------------------------------- Sub myregex() Dim regEx As New VBScript_RegExp_55.RegExp Dim str As String str = "Call me at (982)555-1234!" regEx.Pattern = "(...)...-...." regEx.Global = True regEx.IgnoreCase = True MsgBox regEx.Replace(str, "*") End Sub If I wasn't clear, the output message should be: ************* But, I would also be happy if the output was: (***)***-**** Either way is fine, but the first is better. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Regex Pattern | Excel Programming | |||
Regex as replace function | Excel Programming | |||
Help with a regex pattern please | Excel Programming | |||
Help with a Regex Pattern | Excel Programming | |||
Regex techniques | Excel Programming |