Question

EXCEL多列值合并在一起并且中间用逗号隔开，且不要空值 用什么函数

如下图

在线等 谢谢

Answer 1

先用=IF(A1="","",A1&",")&IF(B1="","",B1&",")&IF(C1="","",C1&",")&IF(D1="","",D1&",")全部用逗号拼接，然后粘贴成文本。最后用=LEFT(E1,LEN(E1)-1)截取掉最后一位

Answer 2

CONCATENATE，可以搞定

Answer 3

E1=A1&","&B1&","&C1&","&D1
下拉公式

追问

我是说如果是空的 就不用逗号 了 ，图片能够看懂把

追答

你看下这样要的不？

=IF(A1="","",A1&",")&IF(B1="","",B1&",")&IF(C1="","",C1&",")&IF(D1="","",D1)

追问

还有一点问题 你看能不能把1,2,3,  3后面的逗号不要

追答

=IF(COUNTIF(A1:D1,"")=1,MAX(A1:D1),IF(A1="","",A1&",")&IF(B1="","",B1&",")&IF(C1="","",C1&",")&IF(D1="","",D1))

追问

虽然不行 还是谢谢你了

追答

=A1&" "&B1&" "&C1&" "&D1
就用空格，间隔。

Answer 4

=trim(a1)&","&trim(a2)&","&trim(a3)&","&trim(a4)