Blank spaces can be present before and after the content from each cell.
They are more likely to be present in columns containing data manually entered by someone, such as a name or a phone number. These spaces are shown as grey squares.
Select a column containing text with blank spaces or a column that you think
may contain some.
- In the functions panel, type Remove trailing and leading characters and click the result to open the options the associated function.
In the Padding character drop-down list, select
Select other to specifiy any other trailing or leading character to be removed.
- Click Submit.
Blank spaces are removed from the selected column.