判斷 提取名稱 (10524)

D2=LOOKUP(1,0/FIND({"乡","乡村"},B2),IF({1,0},LEFT(B2,FIND("乡",B2)),"NULL"))

另解=IFERROR(LEFT(B2,FIND("乡",SUBSTITUTE(B2,"乡村",))),"NULL")

另解=IF(COUNTIF(B2,"*乡村*"),"NULL",LEFT(B2,FIND("乡",B2)))

另解=IF(ISERR(FIND("乡村",B2)),LEFT(B2,FIND("乡",B2)),"NULL")