Find and Replace Using List
Search through a body of text, and use find and replace to replace all matched values with a predefined list of replacements.
The list with replacement values should be either
.csv file with
semicolon delimited values. The first column is the "find" value and the
second column is the "replace" value. The first row is interpreted as the
This function can be handy when you want to replace all special characters in a text file, or when you want to replace month names with month numbers.
Download an example .CSV file for special characters or month.
Example of the Find and Replace Using List function.