Hi

I have a problem concatenating cells, all are formated as text but some have
been taken from another worksheet where the cells have come back with a #N/A
result, in instances where this happened then the concatenate also errors.
What im looking for is a way of concatenating everything that is in the
cells selected even if its a '#N/A' error.