Method 1
Navigate to the entity you wish to update.
Use the edit columns to display the desired fields (A)
Use the filters to add desired selection criteria (B) (for example: Field XXXXX contains *typo)
Select the records you wish to update (A)
Select edit (B)
Make your change (C)
Save (D)
Method 2
Create list view, select columns/fields
Use filters to narrow your list
Export spreadsheet
make updates on exported spreadsheet
import spreadsheet