先看结果,如图。
方法一(优点-简单快速,缺点-无法随单元格A1变化):
选中数据列A:A,【数据-分列】,把一个单元格,按照分隔符号-逗号,进行拆分,即可得到结果。
方法二(优点-结果单元格自动随A1变化,缺点-编写较复杂):
在对应单元格输入【】的内容,单元格内不包含【】
单元格B1——结果显示为123,输入【=MID(A1,1,(FIND(",",A1)-1))】
单元格C1——结果显示为233,输入【=MID(A1,FIND(",",A1)+1,FIND(",",SUBSTITUTE(A1,",",1,1))-FIND(",",A1)-1)】
单元格D1——结果显示为455,输入【=MID(A1,FIND(",",SUBSTITUTE(A1,",",1,1))+1,FIND(",",SUBSTITUTE(SUBSTITUTE(A1,",",1,1),",",1,1))-FIND(",",SUBSTITUTE(A1,",",1,1))-1)】
单元格E1——结果显示为111,输入【=MID(A1,FIND(",",SUBSTITUTE(SUBSTITUTE(A1,",",1,1),",",1,1))+1,LEN(A1)-FIND(",",SUBSTITUTE(SUBSTITUTE(A1,",",1,1),",",1,1))-1)】