Hi,
I have a spreadsheet where I have a formula entered into a cell and dragged down over 4900+ cells. The formula is =LEFT(E2,LEN(E2)-4) effectively it removes the last 4 characters from the cells in the row next to it.
Now not all of the cells used in the calculation contain data, some are empty. When this formula tries to do the calculation on an empty it returns "#VALUE!" in the output cell. Normally I can just click on the cell and delete the formula for that specific one but when I am dealing with 4900+ cells and at least 20% contain an error this is a VERY time consuming process. I have included an example with only 5 or 6 fields filled out, but image it on a much larger scale.
example.xls
Cheers,
Bookmarks