From: tenspeed2 on
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
From: Reeza on
On May 5, 8:30 am, tenspeed2 <tenspe...(a)discussions.microsoft.com>
wrote:
> 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