Microsoft Office Tutorials and References
In Depth Information
It is not necessarily efficient to calculate, but you can solve the
Ctrl+Shift+Enter to accept the formula.
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.
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.