问题1解1=CONCAT(IF(ISNUMBER(FIND({"why";"on";"for"},A3)),{"why";"on";"for"},""))&MID(A3,FIND(" ",A3,FIND(CONCAT(IF(ISNUMBER(FIND({"why";"on";"for"},A3)),{"why";"on";"for"},"")),A3)),
FIND(" ",A3,FIND(" ",A3,FIND(CONCAT(IF(ISNUMBER(FIND({"why";"on";"for"},A3)),{"why";"on";"for"},"")),A3))+1)-FIND(" ",A3,FIND(CONCAT(IF(ISNUMBER(FIND({"why";"on";"for"},A3)),{"why";"on";"for"},"")),A3))+1)
问题1解2=CONCAT(IF(ISNUMBER(FIND({"why";"on";"for"},A3)),{"why";"on";"for"},""))&" "&INDEX(FILTERXML("<a><b>"&SUBSTITUTE(A3," ","</b><b>")&"</b></a>","a/b"),MATCH(CONCAT(IF(ISNUMBER(FIND({"why";"on";"for"},A3)),{"why";"on";"for"},"")),FILTERXML("<a><b>"&SUBSTITUTE(A3," ","</b><b>")&"</b></a>","a/b"),)+1)
|