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 of the following option is NOT present in Office Button? ...
Which of the following tab is used to add the document citation in Microsoft Word? ...
The Excel ____ function returns the Boolean value FALSE. ...
In Excel, which symbol is used to specify the fixed columns or rows in the formula? ...
In EXCEL, you can sum a large range of data by simply selecting a tool button called ________ ...
Which option is correct to save the document in MS Word? ...
Which function is used to trap and handle #N/A errors in Excel? ...
Which criteria do not return the position "Officer" as a match in MS Access? ...
Under which menu can we insert Header and Footer in an Excel sheet? ...