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.
You can see that the First_Name column contains some entries with blank spaces.
- Select the First_Name column.
- In the functions panel, type Remove Whitespaces (Trailing and Leading) and click the result to execute the associated function.
- Repeat this action for every column containing blank spaces.
Blank spaces are removed from the selected column.