本文介绍了单独的换行分为几列的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个带有文字的单元格.文本字符串如下所示:
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.
这篇关于单独的换行分为几列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!