I am using this formula:

mconcat(A1:A100,";")

A1:100 has a formaula in it. In some cases the cell contains #N/A. The
mconcat function does not work in these cases. Is there a way to modify my
formala so that it works even if there is #N/A in the A1;A100 ?

Thank you in advance.