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!"
In Microsoft PowerPoint, the entry effect as one slide replaces another in a show is called a/an ...
An Excel Workbook is a collection of ________ ...
In an Excel worksheet, you can select ...
Which of the following is automatically counted in Microsoft Word? ...
An appointment that happens every year, for example a birthday, is input as ...
Superscript, subscript, outline, emboss, engrave are known as ...
Which criteria do not return the position "Officer" as a match in MS Access? ...
The intersection of a column and a row in a worksheet is called ____ ...
The fill function can be ____ to complete formulas in a range. ...