=TEXT(A1,"000000 0000 0000 0000")
用公式:=LEFT(A1,6)&" "&MID(A1,7,4))&" "&MID(A1,11,4))&" "&RIGHT(A1,4)下拉。
=left(A1,6)&" "&mid(A1,7,4)&" "&mid(A1,11,4)&" " &right(A1,4)
假设在A1,则在B1输入
=TEXT(LEFT(A1,10),"000000 0000 ")&TEXT(RIGHT(A1,8),"0000 0000")