How do I Find and Replace within a Column?
Right-click on a Header (to open the Header Menu).
Select Find & Replace.
Choose what the Filter is to Find and also what the Filter is to Replace:
1. We typed "Internet Explorer."
2. We typed "I.E."
3. We selected the Transform button.
Congratulations, the values have been replaced! Here is a glimpse of what changes took place.
NOTE: This Find and Replace feature does NOT permanently change what is in the database. It simply creates a Prep for your view. If you need to change the actual values inside the database, then you would need to use a Data Process.