在一个单元格内有20个数字，怎么每隔四个数据添加一个空格
<p>假如数据是在A1，在B1使用公式=REPLACE(REPLACE(REPLACE(REPLACE(A1,5,," "),10,," "),15,," "),20,," ")，按回车显示结果。</p> <p><img src="https://res1.wpsacdm.cache.wpscdn.cn/images/433dd7b57398fa78548dce8cda334ce5.jpg" alt=""></p>
頁:
[1]