In MS Excel, which of the following functions can be used to remove all spaces from a text string except for single spaces between words?
- A. TRIM
- B. SUBSTITUTE
- C. CLEAN
- D. REPT
Explanation
TRIM removes leading and trailing spaces and reduces multiple spaces between words to single spaces. CLEAN removes non-printing characters, while SUBSTITUTE replaces specified text rather than automatically normalizing whitespace.