Trim Whitespace removes all spaces in a text string, leaving just a single space between words.
Search not working? This may be why.
This is a quick and easy tool that you can apply to all of your cells.
If you enjoy the video and want to learn more about how to use Google Sheets, check out the Youtube Playlist:
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.