Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up

Which function removes leading and trailing spaces from text?

  1. A CLEAN
  2. B TRIM
  3. C SUBSTITUTE
  4. 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.

All Microsoft excel MCQs

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up as