How do I concatenate below String ignoring comma and NULL values from different cell from A1 to F1.

```
 NULL   NULL    Welcome  NULL    NaiSen     NULL

```

My final result should be: Welcome,NaiSen

I tried using below function but got #VALUE!

```
=CONCATENATE(IF(SEARCH("NULL",A1:F1),"",""))

```