Why the extra arrays?Originally Posted by Cyberdude
[vba]
Sub UberReverse()
Dim ary1
Const OrigStr$ = "Morales Contido, Louis"
ary1 = Split(Replace(OrigStr, ",", ""), " ")
MsgBox OrigStr$ & vbNewLine & ary1(1) & " " & ary1(0) & ", " & ary1(2)
End Sub
[/vba]