Google Sheets - Remove Leading and Trailing Spaces (old method, see description)

thank you so much

Osm dear thank you so much 🥰

You helped me.

Select all offending cells... Data > Trim Whitespace... love it! Thank you for updating your video since it's well SEO'd :)

Holy, you are jesus christ in earth

thank you so much!
had this problem this week.
found your video today, and the description text solved it! thanks!! ;)

Couldn't figure out why Trim wasn't working....thanks for the sub function, did the trick.

Eye Opener
Thank You

I never thought I would ever tell a man this, but: I love you! LOL
Thanks for helping make my life easier.