这样的数据如何分列?答:公式 =IFERROR(MID(SUBSTITUTE($A2,F$1&":","@"),SEARCH("@",IF(ISNUMBER(SEARCH(F$1,$A2)),SUBSTITUTE($A2,F$1&":","@"),""))+1,SEARCH(";",SUBSTITUTE($A2,F$1&":","@"),SEARCH("@",IF(ISNUMBER(SEARCH(F$1,$A2)),SUBSTITUTE($A2,F$1&":","@"),""))+1)-(...
excel如何按条件取数分列?答:1.如图B3输入:=MAX(RIGHT(B2,LEN(B2)-FIND("/",B2)),LEFT(B2,FIND("/",B2)-1))B4输入:=MIN(RIGHT(B2,LEN(B2)-FIND("/",B2)),LEFT(B2,FIND("/",B2)-1))2.选择B3:B4单元格并复制 3.选择B列数据——同时按Ctrl+G调出定位条件,选择空值——确定。4.同时按Ctrl+V粘贴数据。