#Value!

[whis]

=CONCATENATE(B2,C2)

I use the formula above to combine the text, but it give me answer #Value!.....

How to make it Blank if the answer is #Value! ?

 

[Richard Schollar]

Hi Whis

Welcome to the Board!

Does this happen beacuse one of your source cells (ie B2 or C2) contains the error? If so, maybe you could use:

=IF(OR(ISERROR(B2),ISERROR(C2)),"",B2&C2)

Best regards

Richard

 

[preqin]

or- if you mean your doing it on a range of cells and it works on some but not on others (due to the data) then just do a copy- paste special (as values) then do a find and replace #value! with nothing and it will be blank

 

[whis]

Thank you hardSchollar and preqin.

I still got the problem.

1)B1=50 , C1=Like

=CONCATENATE(B1,C1)

answer = 50Like

2)B2=50 , C2=

=CONCATENATE(B2,C2)

answer = #Value!

How to make the #value! = 50 ?

Thank you.

 

[Joe4]

2)B2=50 , C2=

=CONCATENATE(B2,C2)

answer = #Value!

How to make the #value! = 50 ?

I can't reproduce that error.
If cell C2 is truly blank, I get the expected result of "50".

Is cell C2 really blank? If you use the formula =LEN(C2), does it return 0?