Microsoft Office Tutorials and References
In Depth Information
Syntax
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.
Note
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