Use Find and Replace in Excel

[tenspeed2]

I have the following in cells after using a formula. #INVALID_DATA. The
reason is there is no data in the cell. If i use the Find and Replace to
remove the unwanted data in the cells I first use the find all command. I
change the Formulas to Values. I can see the unwanted data at the bottom. I
then use the Replace command. At that time I try to change the Formulas to
Values. There is no Values under the replace. There is a Values in the Find
section. What do I do to replace
#INVALID_DATA in the cells with nothing, like using ""? I do not know what
#INVALID_DATA is. The only way I have found to remove it is to do a copy
paste special command but this only works for one, I have a number of these
to replace.
Thanks for any help on this

 

[Reeza]

I have the following in cells after using a formula. #INVALID_DATA. The
reason is there is no data in the cell. If i use the Find and Replace to
remove the unwanted data in the cells I first use the find all command. I
change the Formulas to Values. I can see the unwanted data at the bottom.I
then use the Replace command. At that time I try to change the Formulas to
Values. There is no Values under the replace. There is a Values in the Find
section. What do I do to replace
#INVALID_DATA in the cells with nothing, like using ""? I do not know what
#INVALID_DATA is. The only way I have found to remove it is to do a copy
paste special command but this only works for one, I have a number of these
to replace.
Thanks for any help on this

What formula are you using?
Perhaps change formula to an if(isna(formula), "", formula)
calculation?

Reeza