Find and Repace on column

[pbt]

I have a spreadsheet where I have created a column to show the Percent Increase based off of two cells. The current price and the increase price. Pretty simple.

My problem is I copied my formula down to the end of my data which is some 1000 rows. In between those rows are blank cells so naturally the Formula returns #DIV/0!.

I clicked on the column that has this formula and did a Ctrl H to replace the #DIV/0! with nothing (no input & with a space), with the Look in Box selected to Formulas. Excel tells me it can't find anything.

My question is, How can I get rid of all the #DIV/0! without having to go to each cell and manually deleting?

It's been awhile since I have been on Mr. Excel, not to mention new computer that is not set up with add-on to portray my sheet.

So to explain below: Third column is formatted as Percent. Formula in that column represent cell address that =(797-766)/766. This formula is copied down, so naturally third column returns the error that I would like to get rid of.

766 797.00 4.05%
729 758.00 3.98%
#DIV/0!
#DIV/0!
766 797.00 4.05%

Any help would be greatly appreciated

 

[Rick Rothstein]

You did not post your formula, so I'll give you a general approach. You can either test the cell for being blank ("") and return "" if it is... or you can wrap your current formula with an IFERROR function call and return "" if the error occurs.

 

[pbt]

Thanks for the Look

I have This formula in Col K =(I4-G4)/G4 which is copied down to 1000 + rows

Being that I am not set up to post my spreadsheet with the add-on for Mr. Excel at this time, I tried to give a verbal of what I needed.

As my previous post shows it take the Large number minus the Small number divided by the Small to give the Percent increase. This works.

The problem is to get rid of the #DIV/0! being that the formula was copied down.