Replace data in a column

Click the Data Manipulation drop-down menu and select Replace Field.
In the Column field, select the column in which you want to replace data.
In the Find Text field, enter the value you want to replace.
Note: The value in the Find Text field must exactly match the entire value in a field for that value to be replaced. For a case-sensitive replace, select the Match Case checkbox.
In the Replace field, enter the new text.
Click OK.

Table of Contents