Microsoft Office Tutorials and References
In Depth Information
Tip 62: Identifying Excess Spaces
Figure 62-3: Using conditional formatting to identify cells that contain excess spaces.
Because of the way the TRIM function works, the formula in Step 4 also applies the
conditional formatting to all numeric cells. A slightly more complex formula that doesn’t
apply the formatting to numeric cells is
Note
=IF(NOT(ISNONTEXT(A1)),A1<>TRIM(A1))
Search JabSto ::




Custom Search