excel表示替换公式

excel表示替换公式

1.2.3.4 1特大2大3中4

 

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

 

posted @ 2023-05-16 09:27  LiuYanYGZ  阅读(164)  评论(0)  编辑  收藏  举报