Removes leading and trailing spaces in a specified string.
81% OFF online library of tutorials for mastering Google Sheets
TRIM()
Description
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 featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.