Calc粘贴后逗号内容挤在一列，怎样按分隔符拆开？

Select the cell or cells that you want to expand. Choose Data - Text to Columns. You see the Text to Columns dialog.

You can expand cells that contain comma separated values (CSV) into multiple cells in the same row.

Select the separator options. The preview shows how the current cell contents will be transformed into multiple cells.

You can select a fixed width and then click the ruler on the preview to set cell breakup positions.

You can select or enter separator characters to define the positions of breaking points. The separator characters are removed from the resulting cell contents.

In the example, you select the comma as a delimiter character.

不推断带引号、字段内逗号等复杂CSV解析。