Excel中怎样自动每隔4个字符加一个空格。或者 总之输入:123j4klo5a786sdf123
Excel中怎样自动每隔4个字符加一个空格。或者 总之输入:123j4klo5a786sdf123
日期:2015-02-16 16:18:58 人气:1
=REPLACE(REPLACE(REPLACE(REPLACE(A1,5,0," "),10,0," "),15,0," "),20,0," ")
Excel中怎样自动每隔4个字符加一个空格。或者 总之输入:123j4klo5a786sdf123