Excel中的批处理字符串连接 [英] Batch string concatenation in Excel

问题描述

我在 Excel 中有几百个单元格，我想将它们连接成一个字符串.是否有比手动逐个检查它们以便将它们输入到 CONCATENATE(A1, A2, ....) 中更简单的方法?

I have a couple hundred of cells in Excel I would like to concatenate into a single string. Is there a simpler method of doing this than going through them one by one manually in order to type them into CONCATENATE(A1, A2, ....)?

CONCATENATE(A1:A255) 不起作用.

推荐答案

*在新选项卡中，在单元格 A1 中键​​入 A1，

*In a new tab, type A1 in cell A1,

*在单元格 A2 中键入 A2

*Type A2 in Cell A2

*使用填充系列来完成A列中的值

*Use fill series to complete the values in column A

*在单元格 B1 中输入 A1

*Type A1 in cell B1

• 在单元格 B2 中使用此论坛

• Use this forumal in cell B2

=B1&","&A2

=B1&","&A2

复制公式.

复制并粘贴值以收集您创建的值字符串.

Copy and paste values to harvest the string of values you created.

A1  A1
A2  A1,A2
A3  A1,A2,A3
A4  A1,A2,A3,A4
A5  A1,A2,A3,A4,A5
A6  A1,A2,A3,A4,A5,A6
A7  A1,A2,A3,A4,A5,A6,A7
A8  A1,A2,A3,A4,A5,A6,A7,A8
A9  A1,A2,A3,A4,A5,A6,A7,A8,A9
A10 A1,A2,A3,A4,A5,A6,A7,A8,A9,A10

这篇关于Excel中的批处理字符串连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！