文本替换

一烟难禁

D2=TEXTJOIN(CHAR(10),,SEQUENCE(COUNTA(TEXTSPLIT(A2,,"；")))&"、"&TEXTSPLIT(A2,,"；"))
E2=TEXTJOIN(CHAR(10),,CHAR(SEQUENCE(COUNTA(TEXTSPLIT(A2,,"；")),1,CODE("①"),1))&"、"&TEXTSPLIT(A2,,"；"))再继续研究其他两题

一烟难禁

A12=SUBSTITUTE(TEXTJOIN("之[注"&SEQUENCE(6)&"]",,TEXTSPLIT(A8,,"之")),"[注1]","",3)收工

Meteor-渣渣

D2公式

1. =SUBSTITUTE(TEXTJOIN(TRIM(MID(SUBSTITUTE(A2,"；",REPT(" ",99)),ROW($1:$9)*99-98,99))&CHAR(10),1,ROW(INDIRECT("1:"&COUNT(0/(MID(A2,ROW($1:$99),1)="；"))+2))&"、"),CHAR(10)&COUNT(0/(MID(A2,ROW($1:$99),1)="；"))+2&"、",)

复制代码

E2公式

1. =SUBSTITUTE(TEXTJOIN(TRIM(MID(SUBSTITUTE(A2,"；",REPT(" ",99)),ROW($1:$9)*99-98,99))&CHAR(10),1,MID("①②③④⑤⑥⑦⑧⑨",ROW(INDIRECT("1:"&COUNT(0/(MID(A2,ROW($1:$99),1)="；"))+2)),1)&"、"),CHAR(10)&MID("①②③④⑤⑥⑦⑧⑨",COUNT(0/(MID(A2,ROW($1:$99),1)="；"))+2,1)&"、",)

复制代码

只会这种笨办法

Meteor-渣渣

A12公式

1. =TEXTJOIN("[注"&ROW(1:6)&"]",1,TRIM(MID(SUBSTITUTE(A8,"之","之"&REPT(" ",999)),ROW(1:9)*999-998,999)))

复制代码

别人是看字符，我怎么是来加字符的……