Home » MCQs » Microsoft Excel MCQs

Which function is used to remove extra spaces from the text in MS Excel?

55. Which function is used to remove extra spaces from the text in MS Excel?

1. REMOVE()
2. TRIM()
3. TRUNC()
4. All of the above

Answer: B) TRIM()

Explanation:

The TRIM() function is used to remove extra spaces from the text in MS Excel.

Syntax:

=TRIM (text)

Example:

=TRIM("     Hello      World!    ") // Returns "Hello World!"