TRIM Function in Excel: Syntax, Examples and Free Practice
TRIM is an Excel Text function. Removes extra spaces from text, leaving single spaces between words.
TRIM syntax
=TRIM(text)
Arguments
text: The text to work with
When to use TRIM
TRIM is used to clean up and reshape text data pulled from other systems before reporting on it.
Practice TRIM online, free
Open the live Excel-style spreadsheet and try TRIM yourself. No Excel install or sign-up needed to start.
Practice TRIM now →Learn more
Read the tutorial: Remove extra spaces with TRIM.
More Text functions
Frequently asked questions
What does the TRIM function do in Excel?
Removes extra spaces from text, leaving single spaces between words.
What is the syntax of TRIM in Excel?
The syntax is =TRIM(text). text: The text to work with.
Where can I practice TRIM online for free?
Open the free live spreadsheet on Cellgrids and try TRIM yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Text functions · Excel case studies · Excel tutorials · Excel shortcuts