请问如何实现excel中两列数据，第一列的每个数据分别与第二列中的每个数据组合，结果放在第三列，谢谢！

Question

可能是我描述的不太准确，我的意思如下图：

Answer 1

=TEXT(A7,0)&TEXT(B7,0)

Answer 2

用公式CONCATENATE

Answer 3

直接用vba写个程序就好了。。。追问

那您帮我写个吧？我不会vba，感激不尽！

追答

Public Sub S123()
Dim i As Integer, l As Integer, j As Integer
i = 1: l = 1: j = 1
Dim A As String, B As String, C As String

A = "A" & i: B = "B" & l: C = "C" & j

Do While Len(Trim(Range(A))) > 0
Do While Len(Trim(Range(B))) > 0
B = "B" & l: C = "C" & j
Range(C).Value = Range(A).Value & Range(B).Value
l = l + 1: j = j + 1
Loop
i = i + 1: l = 1: j = j - 1
A = "A" & i: B = "B" & l: C = "C" & j
Loop

End Sub
这个程序最后会留一个尾巴，记得删了。

本回答被提问者采纳

Answer 4

简单：c1=a1&b1