FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
To remove extra spaces from a string use function
A
Trim
B
Remove
C
Replace
D
Delete
Explanation: 

Detailed explanation-1: -The TRIM function removes all the leading and trailing spaces from a string. In addition to this, it also removes extra spaces between the words within a text, leaving a single space between words. It is mainly used to fix improper spacing in the text.

Detailed explanation-2: -Use JavaScript’s string. replace() method with a regular expression to remove extra spaces. The dedicated RegEx to match any whitespace character is .

Detailed explanation-3: -The Trim function removes all spaces from a string of text except for single spaces between words.

Detailed explanation-4: -Description. Removes all spaces from text except for single spaces between words. Use TRIM on text that you have received from another application that may have irregular spacing.

Detailed explanation-5: -TRIM function-remove extra spaces in Excel You use 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.

There is 1 question to complete.
Previous
Next