在CONCATENATE中使用/n [英] using /n in CONCATENATE

问题描述

除了使用简单的电子表格外，我还很新，可以提供一些帮助.有人告诉我可以在串联的forumla中使用/n代替CHAR(10)，但是发现仅将其替换为/n是行不通的.

I'm pretty new at more than simple spreadsheet use and could use some help. I've been told that I can use /n instead of CHAR(10) in concatenate forumla but am finding that simply replacing it with /n is not working.

= CONCATENATE(B1，"& CHAR(10)，& C1，"& CHAR(10)，"& CHAR(10)，D1，"& CHAR(10))

=CONCATENATE(B1," "&CHAR(10)," "&C1," "&CHAR(10)," "&CHAR(10),D1,""&CHAR(10))

有人可以告诉我这应该是什么样吗?解释可能会有所帮助，但由于我不了解一半的行话，因此如果没有看到完整的结果将无济于事.

Could somebody please show me what this should look like? Explaining might be helpful, but won't help without seeing the full result as I don't understand half the jargon.

谢谢.

推荐答案

我认为您的问题被打上了错误的标签，因为 CONCATENATE 是内置的Excel公式(绝不直接相关)使用C ++).

I think your question is tagged badly, as that CONCATENATE is a built-in Excel Formula (it is in no way directly related to usage of C++).

话虽这么说， CONCATENATE 的正确版本是:

That being said, the correct version of CONCATENATE is:

= CONCATENATE(text，[text2]，[text3]，...)

而且，当您要将换行符连接到单元格(即: \ n 不是 /n )时，应使用 CHAR(10).但是，为了在您应用了串联的单元格中看到换行符，您还必须执行以下操作:

And, as you want to concatenate a newline character to the cell (i.e.: \n not /n), you should use CHAR(10). However, in order to see the newline in the cell that you've applied concatenate on, you also have to do the following:

• 右键单击您正在使用 CONCATENATE 公式的单元格.
• 选择格式选项
• 在数字下，选择文本"作为类别
• 根据对齐方式，有一个子部分称为文本控件".单击显示为自动换行"的复选框.
• 好的.

而且，现在您应该在尝试将 CONCATENATE 应用于其上的任何文本中都看到换行符.

And, now you should see the newline reflected in whatever text you were trying to apply CONCATENATE on.

这篇关于在CONCATENATE中使用/n的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！