Excel中怎样自动每隔4个字符加一个空格。或者 总之输入:123j4klo5a786sdf123

日期:2015-02-16 16:18:58 人气:1

Excel中怎样自动每隔4个字符加一个空格。或者 总之输入:123j4klo5a786sdf123

=REPLACE(REPLACE(REPLACE(REPLACE(A1,5,0," "),10,0," "),15,0," "),20,0," ")
    A+
热门评论