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?
- REMOVE()
- TRIM()
- TRUNC()
- 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!"