View Single Post
 
Old 04-07-2019, 10:26 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

Try this
Code:
Function SortYears(src As String) As String
  Dim arr As Variant, X As Long, coll As Object
  arr = Split(src, " ")
  Set coll = CreateObject("System.Collections.ArrayList")
  For X = LBound(arr) To UBound(arr)
      coll.Add CStr(arr(X))
  Next X
  coll.Sort
  For X = 0 To coll.Count - 1
      SortYears = Trim(SortYears & " " & coll(X))
  Next X
End Function
Reply With Quote