excel表示替换公式

LiuYanYGZ / 2023-05-16 / 原文

excel表示替换公式

1.2.3.4 1特大2大3中4

 

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B14,".","特大",1),".","",1),".","",1),".","",1)&C14