求助求助！饭碗不保！！！如何将12位数字每两位加入空格？？？

MID

先选中该列在设置格式中改为文本，然后在设置格式中选择数字-自定义-类型中输入00 00 00 00 00 00）（两个0中间按空格），点击确定就发现已经更改成想要的格式了

=REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(A1,3,," "),6,," "),9,," "),12,," "),15,," ")

Function lwjkg(sr As String) As String
lwjkg = Left(sr, 2) & " " & Mid(sr, 3, 2) & " " & Mid(sr, 5, 2) & " " & Mid(sr, 7, 2) & " " & Mid(sr, 9, 2) & " " & Right(sr, 2)
End Function

拿去玩。https://pan.baidu.com/s/1Oqb8az2Jd-UYi5wKf1ciXQ

考虑位数为任意位数，n位连上空格或其他符号，自定义函数如下：
Function MyBlank(sr As String, sign As String, num As Integer) As String
Dim i As Integer, length As Integer, arr
length = (Len(sr) - 1) \ num + 1
ReDim arr(1 To length)
For i = 1 To Len(sr) Step num
arr((i - 1) / num + 1) = Mid(sr, i, num)
Next
MyBlank = Join(arr, sign)
End Function
这个函数有三个参数，第一个参数是需要连接的字符，第二个参数连接符号，第三个参数隔n位连接。
如图所示，每四位连接一个空格：

B1输入公式
=MyBlank(A1," "，4)