=LEFT(a1,FIND(" ",a1)-1)&" "&RIGHT(a1,LEN(a1)-FIND(" ",a1,6))&" "&MID(a1,FIND(" ",a1)+1,FIND(" ",a1,6)-FIND(" ",a1))
在B1单元格输入以下公式=LEFT(A1,2)&RIGHT(A1,2)&MID(A1,3,4)
查找 替换
