如果a2:a9分别是字符或数据,a1输入公式=A2&","&A3&","&A4&","&A5&","&A6&","&A7&","&A8&","&A9 即成。
可以使用连接符号“&”连接下面的8格单元格
=offset(a1,7,0)