Question

EXCEL文字排列组合，将前三列每行中的文字排列组合，结果如最后一列。怎么弄？

Answer 1

数据在Sheet1吧，鼠标右击Sheet1的标签【查看代码】在代码窗口粘贴下列代码：
Sub ouyangff()
For i = 2 To [a65536].End(3).Row
For j = 2 To [b65536].End(3).Row
For k = 2 To [c65536].End(3).Row
t = t + 1
Cells(t, 4) = Cells(i, 1) & "-" & Cells(j, 2) & "-" & Cells(k, 3)
Next
Next
Next
End Sub
按F5运行程序，按Alt + F11 回到Excel，去看看D列的结果吧！！！

Answer 2

D2输入
=IF(ROW(A1)>COUNTA(A:A)*COUNTA(B:B)*COUNTA(C:C),"",INDIRECT("A"&INT((ROW(A1)-1)/(COUNTA(B:B)*COUNTA(C:C)))+1)&"-"&INDIRECT("B"&MOD(INT((ROW(A1)-1)/COUNTA(C:C)),COUNTA(B:B))+1)&"-"&INDIRECT("C"&MOD(ROW(A1)-1,COUNTA(C:C))+1))
下拉填充公式。

Answer 3

d2内输入
=a2&“-"&b2&"-"&c2下拉