=A1&B1
是这意思不?
追问=A1&B1
=A1&B2
=A1&B3
=A1&B4
=A1&B5
=A1&B6
=A1&B7
=A1&B8
=A1&B9
=A1&B10
=A1&B11
还有
=A1&B1
=A2&B2
=A3&B3
=A4&B4
=A5&B5
=A6&B6
=A7&B7
=A8&B8
=A9&B9
所有这样的组合
追答=INDEX($A$1:$A$11,MOD(ROW()-1,11)+1)&INDEX($B$1:$B$9,MOD(ROW()-1,9)+1)
上式中11为A列行数,9为B列行数
还有个不用费劲写公式的方法,假定A列2行,B列3行。C,D列依次复制,E列=C&D