TRIM()

Description

Removes leading and trailing spaces in a specified string.

How To Use in Sheets

TRIM(text)

External Links

Trim Formula to remove spaces inside cells with Google Sheets

This video will show you how to remove leading, middle or trailing spaces within a cell. Middle spaces will be trimmed to only one space.

0Better Sheets Tutorials

No videos yet. Stay tuned!