{=IFERROR(EVALUATE(IF(RIGHT(SUBSTITUTE(TRIM(CONCAT(IF(ISERROR(--(0&MID(A11,ROW($1:$800),1)&0)),"*",MID(A11,ROW($1:$800),1)))),"**","*"),1)="*",LEFT(SUBSTITUTE(TRIM(CONCAT(IF(ISERROR(--(0&MID(A11,ROW($1:$800),1)&0)),"*",MID(A11,ROW($1:$800),1)))),"**","*"),LEN(SUBSTITUTE(TRIM(CONCAT(IF(ISERROR(--(0&MID(A11,ROW($1:$800),1)&0)),"*",MID(A11,ROW($1:$800),1)))),"**","*"))-1),SUBSTITUTE(TRIM(CONCAT(IF(ISERROR(--(0&MID(A11,ROW($1:$800),1)&0)),"*",MID(A11,ROW($1:$800),1)))),"**","*"))),"")}哈哈哈,也行,勉强算是解决了