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:
I’m a huge fan of Justin Mares, Mastering Google Sheets course. Sign up today*
*The above affiliate links have been carefully researched to get you to what you specifically need. If you decide to click on one of these links it will cost you just the same as going to the site. If you decide to sign up, I just get a little pocket money to help pay for the costs of running this website.