Given: excel returns #N/A values in certain cells.
It is just a matter of replacing #N/A with new data or applying the following:
- Select all data in spreadsheet (Ctrl +A)
- Find (Ctrl+F) and go to the Replace tab
- Find what should be ‘=’
- Replace with should be a single quote ‘
- 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.