Better Sheets

How to Use TRIM() in Google Sheets

Description

Removes leading and trailing spaces in a specified string.

How To Actually Use TRIM() in Sheets

TRIM(text)

Try TRIM yourself

Use the TRIM formula to remove leading and trailing spaces from the text in cells A1:A10. The result should be displayed in the corresponding cells in B1:B10.

Your formula

Hints (2)

Locale Separator ,

Official Docs

1 Better Sheets Tutorial

Clean Up Names in a List

In this video, I will show you how to clean up a list of names that may have extra white spaces using a formula. I will demonstrate how to identify and remove the extra spaces programmatically, making the list of names unique. By using the TRIM formula, we can easily clean up the names and create a new list with only the unique names. No action is required from you, just watch and learn!

Beginner

TRIM() UNIQUE()

Transcript-matched member videos for TRIM(). Click through to watch.

Browse more tutorials

REGEXMATCH Formula Generator for Google Sheets

Revolutionize the way you handle data with the BetterSheets REGEXMATCHER...

Advanced

IF() REGEXMATCH()

Write Apps Script to Create a New Google Sheets Formula

Create a brand new custom formula in Apps Script. We'll do this for our ...

One Weird Google Sheet Formula for Bulk Publishing With AI

'll show you a game-changing Google Sheet formula that will make your da...

Intermediate

IF() ISBLANK() SUBSTITUTE()

Create a Trello Board with Transpose Formula in Google Sheets

Use Transpose() to create a web-based, Kanban style, list-making applica...