使用道具 举报
baksy 发表于 2021-4-21 13:06 =EVALUATE(SUBSTITUTE(SUBSTITUTE(A2,"*","+")," ","")&0)
cutecpu 发表于 2021-4-21 18:45 =SUM(--(0&TRIM(MID(SUBSTITUTE(A1,"*",REPT(" ",99)),99*ROW($1:$9)-98,99)))) ※數組公式,請記得按Ct ...
Aotenjo168 发表于 2021-4-21 19:03 大师,我反省,提问过于简单不带表格。现附上。
查看全部评分
cutecpu 发表于 2021-4-21 20:03 =SUM(--TEXT(MID(TEXT(MID(SUBSTITUTE("a"&A2,"*",REPT(" ",9)),ROW($1:999),9),),2,9),"0;;;!0")) ※ ...
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-3-29 12:56 , Processed in 0.795934 second(s), 11 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.