# #Value!

#### whis

##### New Member
=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! ?

### Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

#### Richard Schollar

##### MrExcel MVP
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

##### Board Regular
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

##### New Member
Thank you hardSchollar and preqin.

I still got the problem.

1)B1=50 , C1=Like

=CONCATENATE(B1,C1)

2)B2=50 , C2=

=CONCATENATE(B2,C2)

How to make the #value! = 50 ?

Thank you.

#### Joe4

2)B2=50 , C2=

=CONCATENATE(B2,C2)

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?

Replies
7
Views
46
Replies
5
Views
44
Replies
4
Views
61
Replies
3
Views
25
Replies
8
Views
73