Documentation/How Tos/Calc: TRIM function

CALC FUNCTIONS

Text Functions

< Previous Section

Next Section >

FUNCTIONS

• Base
• Char
• Clean
• Code
• Concatenate
• Dollar
• Exact
• Find
• Fixed
• Left
• Len
• Lower
• Mid
• Proper
• Replace
• Rept
• Right
• Search
• Substitute
• T
• Text
• Trim
• Unichar
• Unicode
• Upper
• Value

< Previous Page

Next Page >

TRIM

removes excess spaces from a text string.

Syntax:

TRIM(text)

returns text with any leading or trailing spaces removed, and with any multiple spaces replaced with a single space.

Example:

TRIM("    Good    Morning   ")

returns Good Morning.

---

See Also

• CLEAN
• FIND
• PROPER
• REPLACE
• SEARCH
• SUBSTITUTE

• Text functions

• Functions listed alphabetically
• Functions listed by category