Remove #value

[Wimpie]

Good day

I have a macro that runs in a loop with the formula
=Trim(mid(C1,find(" - ", C1)+2,255))
Because Cdoes not always have data it gives me #value in Column D where the formula runs.
How do I remove all the #value from Column D?

 

[VBA Geek]

=iferror(Trim(mid(C1,find(" - ", C1)+2,255)), "")

 

[dispelthemyth]

FYI
If you had the macro remove the formula and replace with just the value you can use

<code>
Cells.Replace "#Value!", " ", xlWhole
</code>

Good day

I have a macro that runs in a loop with the formula
=Trim(mid(C1,find(" - ", C1)+2,255))
Because Cdoes not always have data it gives me #value in Column D where the formula runs.
How do I remove all the #value from Column D?

 

[Wimpie]

Thank you, i will try both to see which works better for me