Name
TRIM
Synopsis
Use TRIM to remove excess spaces from a text string. The function leaves one space between words in the string and removes all excess spaces.
To Calculate
=TRIM(Text
)
Example
Figure 18-8 illustrates how TRIM is used to remove the extra spaces that may exist within a text string. The example also illustrates how to use UPPER to convert all of the text in the string to uppercase.
Figure 18-8. Use TRIM to ensure that excess spacing has been removed from a text string
Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.