Hi Gurus,
How do I uncount or igonre #N/A values while I concatenate say from cells A1, B1, C1, D1.. where B1 & D1 has #N/A values. I just want to concatenate values without #NA.

A1 - #N/A - C1 - #N/A

If I apply = concatenate(A1,B1,C1,D1) I expect - A1C1

Thanks a bunch