Error handling steps
-
Remove rows with errors: remove rows that contain errors in selected columns
-
Replace errors: replace cells which contain errors with provided value or formula calculation result
-
Clear error cells: clear cells that contain errors (set their value to null)
-
Replace empty values: replace empty values in column with provided value
-
Calculate formula: fix errors in your data using custom formulas