The TRIM function in Google Sheets removes unwanted spaces around text.

TRIM removes the leading, trailing, and repeated spaces in the text values in column A.
The formula is:
=TRIM(A2)🔗 Get this example and others in the template at the bottom of this article.
Continue reading How To Use The TRIM Function In Google Sheets To Clean Your Data