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

 

[tenspeed2]

Remove #INVALID_DATA

I am using the following formula in Excel. =xlqprice(A3).
The stock symbols are in column A2:A300. When I do a pull down
so I can see all the prices in column B there are times there is no
data so I am seeing #INVALID_DATA. I have tried using FIND and
REPLACE. In FIND I change FORMULAS to VALUES. I see all the cells that have #INVALID_DATA so I go to the REPLACE command. Under REPLACE I do not see the VALUES command only the FORMULAS command. I have found that if I go to the cells that have #INVALID_DATA in them and do a copy paste special I can remove the unwanted data.
My question is what can I use WITH =xlqprice(A3) so that I remove just #INVALID_DATA.