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