Which function removes leading and trailing spaces from text?
- A CLEAN
- B TRIM
- C SUBSTITUTE
- D PROPER
Answer
TRIM
Invisible trailing spaces are the single most common reason a lookup fails on values that look identical. CLEAN removes non-printing characters instead.





