How to Remove Extra Spaces in Your Google Sheets Data
Have you ever had extra spaces appear in your Google Sheets data? Whether this happens after importing a file, mistakenly pressing the Space bar, or pasting data, unnecessary spaces in your text can turn into a problem.
Source: howtogeek.com