假设你数据在a1,放结果的起始位置=IFERROR(--LEFT(MID(SUBSTITUTE($A1,"X","*"),SMALL(IF(ISERROR(--MID(SUBSTITUTE($A1,"X","*"),ROW($1:$99),1))*ISNUMBER(--MID(SUBSTITUTE($A1,"X","*"),ROW($2:$100),1)),ROW($2:$100)),COLUMN(A1)),50)&"*",FIND("*",MID(SUBSTITUTE($A1,"X","*"),SMALL(IF(ISERROR(--MID(SUBSTITUTE($A1,"X","*"),ROW($1:$99),1))*ISNUMBER(--MID(SUBSTITUTE($A1,"X","*"),ROW($2:$100),1)),ROW($2:$100)),COLUMN(A1)),50)&"*")-1),"")数组公式,同时按ctrl+shift+回车结束右拉下拉