Which function is used to remove extra spaces from the te...
Which function is used to remove extra spaces from the text in MS Excel?
REMOVE()
TRIM()
TRUNC()
All of the above
Correct answer is B
The TRIM() function in Excel removes extra spaces from text. It deletes all leading, trailing and in-between spaces except for a single space character between words.
Syntax:
=TRIM (text)
Example:
=TRIM(" Hello World! ") // Returns "Hello World!"
What is a collection of worksheets called? ...
What does Sentence Case Option do in Microsoft Word? ...
You can check the conditions against _________ when applying conditional formatting in Excel. ...
You can set your work week to be: ...
A word processor would most likely be used to ...
You want to set up a button to automatically send an email you've received on to your manager, r...
Which programming language is used to write a Macro in MS Excel? ...
Bold, Italic and Underline commands are present in which group in Home tab? ...