filterValues - values that you want to preserve in the specified text
If filterValues doesn’t have any values, an empty string is returned.
Values are text items separated by carriage returns. A value can be empty, a single character, a word, a sentence, or a paragraph. When you press Enter or Return, you start creating a new value. The last value will be recognized with or without a carriage return.
When the textToFilter or the
filterValues parameter is a literal string, you must insert a paragraph character (¶) between each item in the string. To insert a carriage return character, click the
¶ button in the Specify Calculation dialog box.
The FilterValues function is not case-sensitive.