Sorry try this:-
Mick![]()
Dim ray As Variant Dim temp As String Dim i As Integer Dim j As Integer ray = Split([a1], ",") For i = 0 To UBound(ray) For j = i To UBound(ray) If ray(j) < ray(i) Then temp = ray(i) ray(i) = ray(j) ray(j) = temp End If Next j Next i [a2] = Join(ray, ",")
Bookmarks