kerrypnx
10/11/2018 - 7:42 AM

format data ACM

revise 10-11

Dim arr, brr, crr, drr, brr1, firstData, lastData, day
 Selection.Text = Replace(Selection.Text, ",", "")
 If InStr(Selection.Text, " - ") > 0 Then
 arr = Split(Selection.Text, " - ")
 Else
 arr = Split(Selection.Text, "-")
 End If
 brr = Split(arr(0), " ")
 crr = Split(arr(1), " ")
 If Left(brr(1), 1) = "0" Then
    day = Right(brr(1), 1)
 End If
  If Left(crr(1), 1) = "0" Then
    day = Right(crr(1), 1)
 End If
 firstData = day + " " + brr(0)
 lastData = day + " " + crr(0)
 Selection.Text = firstData + ChrW(8211) + lastData + " " + crr(2)