Difference between revisions of "Documentation/How Tos/Calc: TRIM function"

From Apache OpenOffice Wiki
Jump to: navigation, search
(See also:)
m (Robot: Automated text replacement %s)
Line 12: Line 12:
: returns <tt>'''Good Morning'''</tt>.
: returns <tt>'''Good Morning'''</tt>.
=== See also: ===
'''[[Documentation/How_Tos/Calc: CLEAN function|CLEAN]]''',
* [[Documentation/How_Tos/Calc: CLEAN function|CLEAN]]
'''[[Documentation/How_Tos/Calc: FIND function|FIND]]''',
* [[Documentation/How_Tos/Calc: FIND function|FIND]]
'''[[Documentation/How_Tos/Calc: PROPER function|PROPER]]''',
* [[Documentation/How_Tos/Calc: PROPER function|PROPER]]
'''[[Documentation/How_Tos/Calc: REPLACE function|REPLACE]]''',
* [[Documentation/How_Tos/Calc: REPLACE function|REPLACE]]
'''[[Documentation/How_Tos/Calc: SEARCH function|SEARCH]]''',
* [[Documentation/How_Tos/Calc: SEARCH function|SEARCH]]
'''[[Documentation/How_Tos/Calc: SUBSTITUTE function|SUBSTITUTE]]'''
* [[Documentation/How_Tos/Calc: SUBSTITUTE function|SUBSTITUTE]]'''
'''[[Documentation/How_Tos/Calc: Text functions|Text functions]]'''
* [[Documentation/How_Tos/Calc: Text functions|Text functions]]'''
[[Documentation/How_Tos/Calc: Functions listed alphabetically|'''Functions listed alphabetically''']],
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
[[Documentation/How_Tos/Calc: Functions listed by category|'''Functions listed by category''']]
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}

Revision as of 14:24, 25 February 2009


removes excess spaces from a text string.



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


TRIM("    Good    Morning   ")

returns Good Morning.


Personal tools