在Excel中用字符对行进行合并 [英] CONCATENATE rows with character for range in Excel

问题描述

我想为这样的正则表达式连接一个很长的数字列表:

I have a pretty long list of numbers that I would like to concatenate for a regex like this:

2323
2352
3432
…

2323|2352|3432

现在，我显然可以使用 CONCATENATE 函数，但是仍然需要我像这样单独输入每一行:

Now, I can obviously use the CONCATENATE function, but it would still require me to enter each row individually like this:

=CONCATENATE(A1, "|", A2, …)

有什么方法可以将范围和分隔符一起应用?

Is there any way to apply a range together with the splitting character?

推荐答案

通常，这是

Typically this is a job for TEXTJOIN, available in Excel 2019 and O365.

=TEXTJOIN("|",,A1:A3)

这篇关于在Excel中用字符对行进行合并的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！