excel如何快速将多个字符串变成数字?答:【1】先上效果图:【2】步骤 先输入四个公式:E2=IF(F2+G2+H2=0,1,0)F2=IF(ISNUMBER(SEARCH(TEXT(LARGE(A2:D2,1)*10+LARGE(A2:D2,2),"00"),"987654321090")),1,IF(ISNUMBER(SEARCH(TEXT(LARGE(A2:D2,2)*10+LARGE(A2:D2,3),"00"),"987654321090")),1,IF(ISNUMBER(SEARCH(...