excel表格的一个单元格里有abcd四个选项,如何区分在各列里?答:B2=MID(A2,SEARCH(")",A2)+1,SEARCH("B",A2)-SEARCH(")",A2)-1)B2也可以写成:=MID(A2,SEARCH("A",A2),SEARCH("b",A2)-SEARCH("a",A2)-1)C2=MID(A2,SEARCH("B",A2),SEARCH("C",A2)-SEARCH("B",A2)-1)D2=MID(A2,SEARCH("C",A2),SEARCH("D",A2)-SEARCH("C",...