C1公式为:=IF(A1=B1,A1,A1&B1)然后往下拉。希望可以帮到你!
输入A2&b2下拉到你所需要的地方试试看
=IF(A1=B1, A1, CONCATENATE(A1,B1))
=A1&IF(A1=B1,"",B1)
C1中输入:=IF(A1=B1, A1,A1&B1)