CONCATENATE(A,B);

例子:A1和B1的单元格用,号分隔开,并且A1,B1用单引号括起来

CONCATENATE("'",A1,"'",",","'",B1,"'");

如果只是单纯连接俩个单元格用"&"符号就行了


hellowoody
118 声望10 粉丝

个人网站:woodyhello.com