USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
TRIM
|
|
FREEZE
|
|
Either A or B
|
|
None of the above
|
Detailed explanation-1: -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-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 Let’s say we want to remove those spaces for uniformity’s sake. We can use the TRIM function to do that. In a blank column, start by typing the equals sign ( = ) and the word TRIM, then tab into the TRIM function.
Detailed explanation-4: -To trim the values of unwanted spaces, enter the formula =SUBSTITUTE(A22, ” “, ””) in the destination cell or the formula bar. Here, A1 is the cell that contains the untrimmed values. That is, the space (“ “) is replaced by an empty string value (“”).