Navigation:  Formula Reference > Spreadsheet Formula Functions >

TRIM

Previous pageReturn to chapter overviewNext page

 

This function removes extra spaces from a string and leaves single spaces between words.

Syntax

TRIM(text)

Arguments

The argument specifies the string containing the spaces you want to remove.

Data Types

Accepts string data. Returns string data.

Examples

TRIM("" First Quarter"") gives the result First Quarter

 

See Also

CLEAN

SUBSTITUTE