我是一位有用的助手,可以为您进行文本翻译。以下是您需要翻译的内容:
"
例子 B:
"
我想要去除空行,因为:
我在单个Excel单元格中有多行文本。我想要从该文本中删除所有空行。我必须明确表示,我不想删除所有换行符。
示例A:
There is a place where the sidewalk ends
And before the street begins,
And there the grass grows soft and white,
And there the sun burns crimson bright,
And there the moon-bird rests from his flight
To cool in the peppermint wind.
"
...应该翻译成:
"There is a place where the sidewalk ends
And before the street begins,
And there the grass grows soft and white,
And there the sun burns crimson bright,
And there the moon-bird rests from his flight
To cool in the peppermint wind.
例子 B:
There is a place where the sidewalk ends
And before the street begins,
And there the grass grows soft and white,
And there the sun burns crimson bright,
And there the moon-bird rests from his flight
To cool in the peppermint wind.
"
...应该翻译为:
"There is a place where the sidewalk ends
And before the street begins,
And there the grass grows soft and white,
And there the sun burns crimson bright,
And there the moon-bird rests from his flight
To cool in the peppermint wind.
我想要去除空行,因为:
查看电子表格时,可能会看起来某些单元格为空,但实际上它们有几个空行后仍有文本;
我需要清理数据,以便导入到另一个存储解决方案中。
Microsoft有一些关于如何在Excel中去除空格的文档。
但它并没有具体描述去除空行的解决方案:
=SUBSTITUTE(A1, CONCATENATE(CHAR(13),CHAR(10),CHAR(13),CHAR(10)),CONCATENATE(CHAR(13),CHAR(10)))
进行处理,其中A1
是您要处理的单元格。 - Orbling