Can't 'Find' #N/A - "The search item was not found"

[WDSnews]

In Access 2007, I've imported over 3000 rows from an Excel spreadsheet.
There are a few fields containing "#N/A" (without the quotes), which I wish
to find and manually correct. However the Find and Replace tool fails to
find them. I can search and Find "N/A", but that doesn't allow me to
replace all four characters of "#N/A". So I want to search and Find "#N/A".

As usual, the new Help system fails to help. Isn't it amazing the new help
system is able to offer 100 documents to view, and not one of them is
appropriate to the question of "Find symbol", or "Find #"? (Earlier this
week, I searched Word help for "Outlining Keyboard Shortcuts". Phewey!)

Thanks for your help.

 

[WDSnews]

AHA! I found it 2/3rds down a long Help article titled "Access wildcard
character reference". The solution is to search for "[#]N/A". You can see
that article listed if you search for "Find symbol", skip the first 25
articles and look halfway down the list of the second 25 articles.

 

[Rastro]

You could make a Find&Replace with a sql sentence like this one:
----------
UPDATE Table SET Table.Field = Null WHERE Table.Field = "#N/A";
----------

Replace the objects (table, field) with their names and Null with the
replacement value. If you want to clear the field you need to leave it as it
is (field=null)

Hope it helps