单独的换行分为几列 [英] Separate line breaks into columns

问题描述

我有一个带有文字的单元格.文本字符串如下所示:

I have one cell with text. The text string looks like the following:

Lorem Ipsum is simply 
dummy text of the printing 
and typesetting industry. 
Lorem Ipsum
has been the
industry's standard 
dummy text.

我阅读使用Text-to-column，用作定界符Other，并在其他"字段中按Alt 0010进行填写.

I read to use Text-to-column, use as delimiter Other and fill in by pressing Alt 0010 in the Other field.

但是，只有第一行停留.

However, only the first row stays.

我想要的结果是:

有人建议如何按换行符分隔吗?

Any suggestions how to separate by line break?

推荐答案

使用数据►文本到列，定界.

Use Data ► Text to Columns, Delimited.

在第二个屏幕上，选择[ctrl] + J作为分隔符的其他". [ctrl] + J是换行符CHAR(10).

On the second screen opt for Other with [ctrl]+J as the delimiter. [ctrl]+J is CHAR(10), the line feed character.

在第三个屏幕上，选择B1作为目的地.

On the third screen, choose B1 for a destination.

这篇关于单独的换行分为几列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！