- ·上一篇：excel锁定公式$怎么打
- ·下一篇：excel表格怎么看户数
excel怎么添加单元格空格
2026-01-13 10:37:54
1.excel添加 空格
设数据如图：
将公式
=REPLACE(REPLACE(REPLACE(A1,4,0," "),8,0," "),12,0," ")
复制后粘贴到"B1"单元格，对准右下角，光标成"+"状时双击，如图：
设数据如图：
将公式
=REPLACE(REPLACE(REPLACE(A1,4,0," "),8,0," "),12,0," ")
复制后粘贴到"B1"单元格，对准右下角，光标成"+"状时双击，如图：