EXCE中利用REPLACE来实现在某段字符串中每隔几个字符增加一个符号方法:
等式=REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(B10,5," “),10,” “),15,” “),20,” “),25,” “)
当>25位时,请增加REPLACE(等式,30,” ")即可,如此类推
EXCE中利用REPLACE来实现在某段字符串中每隔几个字符增加一个符号方法:
等式=REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(B10,5," “),10,” “),15,” “),20,” “),25,” “)
当>25位时,请增加REPLACE(等式,30,” ")即可,如此类推