Replace the text in multiple fields within an attribute table using the Find and Replace tool

Last Published: October 12, 2021


An attribute table is a database entity that contains nonspatial information about a set of geographic features in a geographic information system (GIS). The information is arranged so that each row represents a feature and each column represents one feature attribute. In ArcGIS, rows are known as records and columns are fields. Each field stores a specific type of data, such as a number, date, or piece of text.

The instructions provided describe how to use the 'Find and Replace' tool to replace the text in multiple fields within an attribute table without editing every record.


To replace the values in an attribute table:

  1. Open the feature class or the shapefile in ArcMap.
  2. Open the attribute table of the layer.
  3. Click the Editor menu on the Editor toolbar, and select Start Editing.
  4. On the attribute table, select the field to be edited. This is to ensure only the selected field is amended.
  1. Click the Table Options icon at the top left corner of the table and select the Find and Replace command.
  2. Click the Replace tab in the Find and Replace dialog box.
  3. In the Find what box, type the character or string to be edited.
  4. In the Replace with box, input the character or string to be replaced with and ensure the Search Only Selected Field(s) is checked.
  1. Click the Replace All button to replace all the values at once, and close the dialog box.
  2. On the Editor toolbar, go to the Editor menu.
  3. Select Save Edits, and click Stop Editing.

Article ID:000012044

  • ArcMap

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options