81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



Removes leading and trailing spaces in a specified string.

How To Use in Sheets


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 featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.