![]() |
#14
|
||||
|
||||
![]()
Try:
Code:
Function ParseIt(StrIn As Variant) As Variant Dim i As Long, j As Long, k As Long Dim StrTmp As String, StrOut As String If IsNumeric(StrIn) Then ParseIt = StrIn Exit Function End If For i = 0 To UBound(Split(StrIn, ",")) StrTmp = Split(Split(Split(StrIn, ",")(i), "+")(0), "-")(0) k = Len(StrTmp) For j = k To 1 Step -1 If Not IsNumeric(Mid(StrTmp, j, 1)) Then StrTmp = Replace(StrTmp, Mid(StrTmp, j, 1), "") End If Next StrOut = StrOut & StrTmp & "," Next ParseIt = Left(StrOut, Len(StrOut) - 1) End Function
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
JAMS | Excel | 2 | 04-06-2012 10:14 PM |
Meeting Request Time Wrong | aimav | Outlook | 0 | 03-26-2012 08:14 AM |
Outlook Calendar request | steve42399 | Outlook | 2 | 04-12-2011 09:35 AM |
Meeting Request - Another Organizer | coolpeter86 | Outlook | 0 | 12-12-2010 11:58 PM |
Macro request: open on event | infotech | Outlook | 0 | 12-08-2010 06:40 PM |