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?

Question: 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. A) TRIM ✓
B. B) SUBSTITUTE
C. C) CLEAN
D. D) REPT

Correct Answer: A. A) TRIM

Explanation: Trim is correct answer, it is used to remove all spaces from a text string except for single spaces between words.

Related Posts

Leave a Comment Cancel Reply