[已解决]按某符号反复取值求助

cutecpu

Aotenjo168 发表于 2021-2-7 18:01
阿弥陀佛，版主，如今我已经安装了Excel2019，1楼的问题能用TEXTJOIN 函數了。

=A2&"*"&C2&REPT("-",B2>0)&TEXTJOIN("-",,TRIM(RIGHT(SUBSTITUTE(MID(SUBSTITUTE(SUBSTITUTE($B2,CHAR(10)," ")," ",REPT(" ",99)),ROW($1:$9)*99-98,99),":",REPT(" ",99)),99)))&";"
祝順心，南無阿彌陀佛！