I have a question related to this thread. If I have:
A2 = Smith
B2 = Taylor
C2 = Miller

I can use
=CONCATENATE(A2,B2,C2) to get SmithTaylorMiller.

But if I have
A2 = Smith
B2 = #N/A
C2 = Miller
...using the same formula, I just get #N/A.
Is there a way to get the results of A2 and C2, even if B2 has #N/A?
I would like a result like Smith#N/AMiller.
Possible?