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
写代码来处理就好了追问有时间给写一个吗？谢谢！
