你这是要最后一个逗号后面的内容吧
假设这些数据写在A列
则B1单元格写入公式
=MID(A1,FIND("⊕",SUBSTITUTE(A1,",","⊕",LEN(A1)-LEN(SUBSTITUTE(A1,",",))))+1,LEN(A1)-FIND("⊕",SUBSTITUTE(A1,",","⊕",LEN(A1)-LEN(SUBSTITUTE(A1,",",)))))
或
=MID(A1,FIND("⊕",SUBSTITUTE(A1,",","⊕",LEN(A1)-LEN(SUBSTITUTE(A1,",",))))+1,999)
下拉复制公式
更简单的方法是用"数据---分列"来做
选中数据所在列---数据---分列---分隔符号---勾选"其他"写入",“逗号---"列数据格式"选择"不导入此列"---保留要的内容列----完成