Sub cob() n = Range("F65536").End(xlUp).Row r = 1 For n1 = 1 To n - 2 For n2 = n1 + 1 To n - 1 For n3 = n2 + 1 To n Range("G" & r) = Range("F" & n1) & Range("F" & n2) & Range("F" & n3) r = r + 1 Next Next NextEnd Sub
用VBA更简单一点。
组3个字母,