Excel单元格如何替换数据？

发布网友发布时间：2022-03-08 23:11

共2个回答

热心网友时间：2022-03-09 00:40

没有TEXTJOIN很麻烦的，你说最多6个那么就多几个替换把
=SUBSTITUTE(LEFT(A1,3)&"="&REPLACE(REPLACE(REPLACE(REPLACE(REPLACE("'"&SUBSTITUTE(SUBSTITUTE(A1,"/&","' OR '"),"&","' AN '")&"'",66,,IF(LEN(A1)>46,MID(SUBSTITUTE(A1,"/",),41,3)&"=","")),53,,IF(LEN(A1)>38,MID(SUBSTITUTE(A1,"/",),33,3)&"=","")),40,,IF(LEN(A1)>30,MID(SUBSTITUTE(A1,"/",),25,3)&"=","")),27,,IF(LEN(A1)>22,MID(SUBSTITUTE(A1,"/",),17,3)&"=","")),14,,IF(LEN(A1)>14,MID(SUBSTITUTE(A1,"/",),9,3)&"=",""))," AN"," AND")

热心网友时间：2022-03-09 02:15

写代码来处理就好了追问有时间给写一个吗？谢谢！

首页

文章

Excel单元格如何替换数据？