假设那些数据在A1:A100中,B1中输入=IF(-1^LOOKUP(10,--RIGHT(LEFT(A1,ROW($1:$9))))=1,"女","男")&MID("服鞋",LOOKUP(,0/(FIND({"F","E"},A1)),{1,2}),1)下拉.
客至(杜甫)
