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!"
Excel Paste Special command lets you copy and paste ...
What is the default file extension of MS Access? ...
A __________ lets you place a block of text at a specific location within your document. ...
Paragraph group is present under which tab in Microsoft Word? ...
In MS Access, how can you make a date field DOB store the dates like "2002/10/17" ? ...
What is the keyboard shortcut to start the slideshow of a PowerPoint presentation? ...
Title Bar is present at the _________ of the Quick Access Toolbar. ...