互調前後二字符串 (14050)

B2=MID(A2&" "&A2,FIND(" ",A2)+1,LEN(A2))

另解=MID(A2,FIND(" ",A2)+1,99)&" "&LEFT(A2,FIND(" ",A2)-1)

另解=REPLACE(A2,1,FIND(" ",A2),)&" "&LEFT(A2,FIND(" ",A2)-1)