在Excel中批量字符串连接 [英] Batch string concatenation in Excel

问题描述

我在Excel中有几百个单元格，我想连接成一个单一的字符串。有没有一个更简单的方法来做这个，而不是一个一个地手动地将它们输入到 CONCATENATE（A1，A2，....）？

CONCATENATE（A1：A255）无效。

解决方案

*在新标签中，在单元格A1中键入A1，

*在单元格A2中键入A2

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

*在单元格B1中键入A1

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

  
  
  

  = B1&，& A2

  / li>
  

• 复制公式。

将值复制并粘贴到收获您创建的一系列价值。

  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 
  

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) does not work.

解决方案

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

*Type A2 in Cell A2

*Use fill series to complete the values in column A

*Type A1 in cell B1

• Use this forumal in cell B2

  =B1&","&A2

• Copy the formula down.

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屋！