![]() |
#13
|
|||
|
|||
![]()
Hi
I was provided with a UDF by Macropod a couple of years ago which I need modifying. Basically I need the UDF modified. The UDF basically converts values like "365SS+4wks, 175" to "365, 175". Where I need the UDF changed is allow values such as "23,456,567,666" to remain as shown. Here is a copy of the UDF: 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 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 Tony |
|
![]() |
||||
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 |