Trim formula

The TRIM function in Google Sheets is a nifty little tool that is especially useful for cleaning up those unnecessary spaces in your spreadsheets.

How to use?

SYNTAX: =TRIM(text)
text - The string or reference to a cell containing a string to be trimmed.

Practice Sheet

The below sheet is view only mode, please make a copy to practice.

Copy of Trim Function

Make a copy

Page updated

Google Sites

Report abuse