每四位自动分隔 (11193)

C2=TEXT(B2,LEFT(REPT("0000 ",9),LEN(B2)/4+LEN(B2)))

另解 C2=TEXT(B2,TRIM(LEFT(REPT("0000 ",5),LEN(B2)+INT(LEN(B2)/4))))

D2=TEXT(B2,RIGHT(TRIM(REPT("0000 ",9)),LEN(B2)/4+LEN(B2)))