单独分列出姓名
B1输入
=IF(ISNUMBER(--RIGHT(A1)),LEFT(MID(A1,FIND(",",A1)+1,99),LENB(MID(A1,FIND(",",A1)+1,99))-LEN(MID(A1,FIND(",",A1)+1,99))),RIGHT(MID(A1,FIND(",",A1)+1,99),LENB(MID(A1,FIND(",",A1)+1,99))-LEN(MID(A1,FIND(",",A1)+1,99))))
公式下拉
还是不对,取得都是后三位