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!"
Which is not a Text function in MS Excel? ...
A document's margins are adjusted using the ______ in Microsoft Word. ...
(IF [Age]>65, "Senior","Adult"). In Ms Access, this expression is an example ...
Which of the following is NOT a command in MS Word Insert tab? ...
You need to arrange a meeting for all employees in a particular department - do you: ...
In MS Word, Ctrl+S is used to ________ ...
How can you quickly reinstate a deleted footer placeholder in PowerPoint master view? ...
Under which group in Home tab you can create first line indent? ...