You can remove the content of cells that match a value or a pattern that you have defined.
- Select the column in which you want to remove the content that matches your pattern.
- In the Functions panel, type Clear on matching value and click the result to open the options for the associated function.
- Enter the value that you want to match and the operator you want to use.
- Click the submit button to apply the function with the selected options.
The content of the cells that correspond to the pattern that you have defined is removed.