DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Trim
|
|
|
Remove
|
|
|
Replace
|
|
|
Delete
|
Detailed explanation-1: -The trim() function removes whitespace and other predefined characters from both sides of a string. Related functions: ltrim()-Removes whitespace or other predefined characters from the left side of a string.
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: -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. Important: The TRIM function was designed to trim the 7-bit ASCII space character (value 32) from text.
Detailed explanation-4: -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.