FUNCTION CATALOGUE / TEXT
TRIM Excel function
Removes excess spaces.
Correct sentence to use
Remove extra spaces from [text].
Modify this query in PlainFormula →Example formula
=TRIM(A2)
Removes leading, trailing and repeated ASCII spaces.
Syntax
TRIM(text)
Argument signature: text
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.