Current lesson | Lesson 9/31

Custom Validation Rules: Empty Cells, TRIM, and Email Format

Advanced Excel – Data Analysis, Power Query and Pivot Tables 0%
Let's see how to create custom validation rules with formulas to handle complex inputs: I'll explain how to block empty cells, strip unwanted spaces with TRIM, and verify that a field contains a valid email format.
Instructor
Up next Custom Sorting and Qualitative Variables in Excel