excel 1列数据中两个到多个单元格的合并 而且使用,号隔开？

Question

如图，用什么公式能实现合并

Answer 1

公式为：

=TEXTJOIN(",",,A$1:A1)


如图所示：

Answer 2

b2=B1&A1&","&A2下拉

Answer 3

VBA

Sub aa()

Dim i

[b2] = [a1] & "," & [a2]

For i = 2 To Range("a65536").End(xlUp).Row-1

    Cells(i + 1, "b") = Cells(i, "b") & "," & Cells(i + 1, "a")

    Next

End Sub

本回答被网友采纳