Microsoft Office Tutorials and References
In Depth Information
Syntax:
Note
It is not necessarily efficient to calculate, but you can solve the
trailing
spaces
in
column
F
by
using
=VLOOKUP(A2,TRIM(F$2:G$5),2,FALSE)
if
you
press
Ctrl+Shift+Enter to accept the formula.
Syntax:
=TRIM(text)
The TRIM function removes all spaces from text except for single spaces
between words. You use TRIM on text that you have received from another ap-
plication that might have irregular spacing. The argument textis the text from
which you want spaces removed.
In Figure 11.54 , cell C1 contains six letters: ABC DEF. You might assume that
the cell is set to be centered. However, the formula in cell C2 appends an as-
terisk to each end of the value in cell C1. This formula shows that there are
several leading and trailing spaces in the value.
Search JabSto ::




Custom Search