To
search the Data View window for a particular value to replace
Right-click
a cell in the column that you want to search. Click Replace.
Enter
a value to search for in Find What.
Enter
a replacement value in Replace With.
Click
Find Next.
Do
one of the following:
Click
Replace to replace the current occurrence of the search value.
Click
Replace All to replace all occurrences of the search value.
Repeat
steps 4 and 5 to replace additional occurrences of the value you're searching
for.
NoteThe Replace option limits its search to
records contained in the same column as the currently selected cell.
There is no way to issue a global Replace command that searches
the entire database table for a specific value. You must select individual
cells in any additional columns you want to search, and then click Replace
again.