EXCEL如何拆分以分隔符号或空格分隔的数据答:" "},ROW(INDIRECT("a1:a"&LEN($A2))),65535),COLUMN(A1))-IF(COLUMN(A1)=1,0,SMALL(IF(MID($A2,ROW(INDIRECT("a1:a"&LEN($A2))),1)={"+"," "},ROW(INDIRECT("a1:a"&LEN($A2))),65534),COLUMN(A1)-1))-1)然后按ctrl+shift+回车。这时编辑栏里的公式会被一对大括号{...