如题所述
方法1:=A2&B2&C2
方法2:=TEXTJOIN("",TRUE,A2:C2)
方法3(如果非要用IF函数):=TEXTJOIN(",",TRUE,IF(A2:C2<>"",A2:C2,"")) ,再按ctrl+shift+enter