企业官网建设流程全解析

=LET(文本,SUBSTITUTE(D1,CHAR(10),","),长度,LEN(文本),结果,REDUCE("",SEQUENCE(长度),LAMBDA(累计值,i,LET(字符,MID(文本,i,1),编码,CODE(字符),IF(编码<128,累计值&字符,LET(最后一个字符,IF(累计值="","",RIGHT(累计值,1)),IF(最后一个字符=",",累计值,累计值&",")))))),清理1,TRIM(结果),清理2,SUBSTITUTE(清理1," ",","),清理3,SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(清理2,",,",","),",,",","),",,",","),清理3)