An administrator wants to prevent users from accidentally entering leading or trailing whitespace in email address fields. Which formula function should be used in a Validation Rule?
TRIM() strips leading and trailing spaces from the email value before comparison, so a validation rule can reject entries containing stray whitespace. It targets exactly the constraint in the stem, unlike functions that only alter case or substitute characters.
Why this answer
The TRIM() function removes leading and trailing spaces from a text string, helping validate cleanliness.