How do I get rid of #VALUE! AND 0

[rcirone]

#VALUE ! AND 0

How do I get rid of these when I use this code
=MID(LEFT(ues!C2,LEN(ues!C2)-11),FIND(" ",ues!C2)+1,255)&", "&LEFT(ues!C2,FIND(" ",ues!C2))
and this one too
=MID(LEFT(ues!C2,LEN(ues!C2)-11),FIND(" ",ues!C2)+1,255)&", "&LEFT(ues!C2,FIND(" ",ues!C2))&"ICE"

 

[mole999]

this should work
=IFERROR(MID(LEFT(ues!C2,LEN(ues!C2)-11),FIND(" ",ues!C2)+1,255)&", "&LEFT(ues!C2,FIND(" ",ues!C2)),"")

 

[rcirone]

Thanks

 

[rcirone]

Is there a way I can do it with this code

=((U2*0.2)+(V2*0.4)+(W2*0.4))*10

 

[mole999]

is that the zero or error, the same wrapping can be used

 

[rcirone]

no it is #value and not 0 or error I tried it

 

[rcirone]

I got it thanks for the help