How to fix #N/A errors in excel

Given: excel returns #N/A values in certain cells.

Solution:
It is just a matter of replacing #N/A with new data or applying the following:

  1. Select all data in spreadsheet (Ctrl +A)
  2. Find (Ctrl+F) and go to the Replace tab
  3. Find what should be ‘=’
  4. Replace with should be a single quote ‘
  5. Hit replace all

That’s it — easy as a charm! And works for me in Excel 2007.

There’s also another, more proactive way of fixing this, using the IFERROR function to evaluate the #N/A error upfront.

Leave a Reply

Your email address will not be published. Required fields are marked *