Hi Dave, thanks for your reply

The only formula that i have a problem with is the concatenate one. i will
try and example.

my command =CONCATENATE(A1,B1,C1)

A1 = "15"
B1 = "SAUSAGES"
C1 = "INAPAN"

this results 15SAUSAGESINAPAN

A1 = "15"
B1 = "SAUSAGES"
C1 = "#N/A"

this results #N/A

what i am trying to achieve is the result 15SAUSAGES#N/A

I hope this makes more sense,

thanks
Bry




"Dave F" wrote:

What errors are you seeing? Post the specific formula you are using and any
errors which are returned.

Dave
--
Brevity is the soul of wit.


"Bry" wrote:

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.