Computer MCQs for Competitive Exams, MS Excell MCQS | By

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.

Leave a Comment

Your email address will not be published. Required fields are marked *

Related Posts

Scroll to Top