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!"
By using the ___, we can see all slides at once in PowerPoint. ...
Which of the following command is not present in Review tab of Microsoft Word? ...
What is the extension of a Microsoft Excel file? ...
Which of the following is a type of checkbox available in MS Word? ...
Under which PowerPoint menu are the options for draw/insert Text Box, picture, charts available? ...
Cascade update option in Access ...
To create a formula in Excel, you first ...