万能提取公式

=LAMBDA(y,x,

LET(

  a,MID(y,ROW(INDIRECT("1:"&LEN(y))),1),

  b, CONCAT(

      IF(x="hz",IF(LEN(a)<>LENB(a),a," "),

      IF(x="zm",IF((UPPER(a)>="A")*(UPPER(a)<="Z"),a," "),

      IF(x="sz",IF(ISNUMBER(FIND(a,-1/17)),a,""),

      IF(ISNUMBER(FIND(a,x)),a," "))))

 ),

 c,LEN(TRIM(b))-LEN(SUBSTITUTE(TRIM(b)," ",""))+1,

 d,SUBSTITUTE(TRIM(b)," ",REPT(" ",99)),

 e,TRANSPOSE(TRIM(MID(d,99*ROW(INDIRECT("1:"&c))-98,99))),e)

)