Remove Extra Spaces From Data In Google Spreadsheets
When text data is imported or copied into a Google spreadsheet, extra spaces are sometimes included along with the text data. On a computer, a space between words is not a blank area but a character, and these extra characters can affect how data is used in a worksheet — such as in the CONCATENATE function, which combines multiple cells of data into one. Rather than manually editing the data to remove the unwanted spaces, use the TRIM function to remove the extra spaces from between the words or other text strings....