Excel Function

TRIM

Removes extra spaces from text.

TRIM(text)

Arguments

text

Required

Enter a text value (wrap with quotes when needed).

Practice Preview

format and display text values. Use TRIM to Removes extra spaces from text. use B2 for text. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=TRIM(B2)

Practice This Function

Practice in Sequential Mode Back to Function List