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.

Note

The list with replacement values should be either .txt or .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 headers.

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.