Automatic find / replace
Find and replace one or more characters based on a set of rules.
Performing a find/replace once in Excel is easy but it quickly gets frustrating when you have to do it every time new data comes in. However find/replace can be necessary to do things such as cleanup common typos or standardize names (e.g. United Kingdom vs. UK).
Use a “Find/Replace” object to describe find/replace rules and it will automatically apply them in order to your data whenever new data comes in.