TRIM

Trims all the spaces from a text string.

Syntax

TRIM(text-expression)

Arguments

text-expression

Text, number, or cell reference to trim.

Example

VALUE("Go be Productive") returns  "gobeProductive".