A1=123
A2=456
A3="123 456"
B1=MID(A1,1,1)&MID(A1,2,1)&MID(A1,3,1)&" "&MID(A1,1,1)&MID(A1,3,1)&MID(A1,2,1)&" "&MID(A1,2,1)&MID(A1,1,1)&MID(A1,3,1)&" "&MID(A1,2,1)&MID(A1,3,1)&MID(A1,1,1)&" "&MID(A1,3,1)&MID(A1,1,1)&MID(A1,2,1)&" "&MID(A1,3,1)&MID(A1,2,1)&MID(A1,1,1)
下拉到B2
B3=B1&" "&B2如图: