比如两者之间是用空格相隔的
=IF(LEN(LEFT(A1,FIND(" ",A1)-1))=11,A1,RIGHT(A1,LEN(A1)-FIND(" ",A1))&" "&LEFT(A1,FIND(" ",A1)))
如果不是用空格隔开,是用符号的,在FIND函数的双引号中间加上你的符号并去除空格,比如用逗号隔开的在函数的公式改成如下
=IF(LEN(LEFT(A1,FIND(",",A1)-1))=11,A1,RIGHT(A1,LEN(A1)-FIND(",",A1))&","&LEFT(A1,FIND(",",A1)))
温馨提示:答案为网友推荐,仅供参考