DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
It removes a specific number of characters from a text string.
|
|
|
It removes all non-printable characters.
|
|
|
It removes all spaces from a text string except single spaces between words.
|
|
|
None of the above options are correct.
|
Detailed explanation-1: -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. Important: The TRIM function was designed to trim the 7-bit ASCII space character (value 32) from text.
Detailed explanation-2: -The TRIM function removes all spaces from text except a single space between words. Use this function when you have text data that contains hidden spaces in the cell.
Detailed explanation-3: -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.
Detailed explanation-4: -Google Sheets trims text input into cells by default. It is important to use TRIM when text is used in formulas or data validation because spaces in front of or after the text are significant. TRIM removes all spaces in a text string, leaving just a single space between words.