Why use code tags? Using code tags makes it much easier to read your code, because without them, your code looks like this:
Sub SplitNameWithInstrrevJoinJr()
Dim c As Range, i As Integer
Dim first As String, last As String
For Each c In Range("A1:A" & Range("A65536").End(xlUp).Row)
If...