Microsoft Office Tutorials and References
In Depth Information
Figure 11.57.
Figure 11.57. CODE
CODE is instrumental in learning why the
is instrumental in learning why the TRIM
TRIM function won t
function won t
work on the data in column A.
The formula in B2 shows the character number for the second character in
A2. The space is a character 160 instead of a typical space character 32.
Excel pros know that they can remove the extra interior spaces by
using =TRIM(A2). But TRIM still doesn t remove nonbreaking spaces.
Search JabSto ::

Custom Search