TRIM

See also A-Z Spreadsheet Function List

Description Removes all spaces from text except single spaces between words.

Syntax TRIM(text)

text is any text string or a reference to a cell that contains a text string.

Remarks Text that is imported from another environment may require this function.

See Also CLEAN , MID , REPLACE , and SUBSTITUTE functions

Example TRIM(“ Level 3, Gate 45 ”) returns “Level 3, Gate 45”