比如你的字符串在A1中在B1输入公式：=IF(ISERROR(--TRIM(MID(SUBSTITUTE($A1,",",REPT(" ",99)),COLUMN(A1)*99-98,99))),"",(--TRIM(MID(SUBSTITUTE($A1,",",REPT(" ",99)),COLUMN(A1)*99-98,99))))往右一直拉即可
数据》分列》分隔符号》逗号
