excel 如何把一列包括符号和没有符号的数据自动分成两列

以下是对这段文字的改写：

The formula in B1 can be written as follows:INDEX($A:$A,SMALL(IF(ISERROR(FIND("/",$A$1:$A$16)),ROW($A$1:$A$16),4^8),ROW(A1)))The formula in C1 can be written as follows:INDEX($A:$A,SMALL(IF(ISERROR(FIND("/",$A$1:$A$16)),4^8,ROW($A$1:$A$16)),ROW(A1)))In order to copy this array formula down, you need to enter the following steps：Enter the formula in B1 and click on the "Enter" key. The cursor will become a double cross (?) in the formula bar.Click anywhere in the cell to the right of B1 to insert the second formula, C1. The cursor will become a cross (×) in the formula bar.Press and hold both the "Ctrl" and "Shift" keys, then press "Enter". This will enter the array formula at once.