-
列转行,逗号分隔 TEXTJOIN(",",TRUE,B1:B25) true忽略空值B列1-25行数据转为一行显示中间用逗号隔开
-
小写金额转大写 单元格 K141替换为小写金额的地址
- ="总金额(大写)"&SUBSTITUTE(SUBSTITUTE(IF(K141>-0.5%,,"负")&TEXT(INT(FIXED(ABS(K141))),"[dbnum2]G/通用格式元;;")&TEXT(RIGHT(FIXED(K141),2),"[dbnum2]0角0分;;"&IF(ABS(K141)>1%,"整",)),"零角",IF(ABS(K141)<1,,"零")),"零分","整")
excel 方法
于 2023-11-07 00:53:42 首次发布