Multiple choice technology

Trim("…..ABC…DEF….',".") =?

  1. ABC…DEF

  2. ABCDEF

  3. …..ABC…DEF….

  4. None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The TRIM function removes all leading and trailing occurrences of the specified character. TRIM(".....ABC...DEF....", ".") removes all dots from the start and end, leaving "ABC...DEF" (the internal dots between C and D remain). Option B incorrectly removes all dots, and option C shows the unchanged input.

Keep practicing — related questions