DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
only the first
|
|
|
first and last
|
|
|
only the last
|
|
|
only the middle
|
Detailed explanation-1: -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-2: -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-3: -The TRIM function: Removes spaces from start and end of text string. Removes all except single spaces between words.
Detailed explanation-4: -The STRIP function is similar to the TRIM function. It removes both the leading and trailing spaces from a character string.