Excel分列功能的妙用

如何把一列变两列，内容也跟着分开呢？？

如下：

如何变成以下两列呢？？

B C

b1=IF(ISERROR(FIND(",",A1)),A1,IF(FIND(",",A1),LEFT(A1,FIND(",",A1)-1)))

c1=IF(ISERROR(FIND(",",A1)),A1,IF(FIND(",",A1),RIGHT(A1,LEN(A1)-FIND(",",A1))))