Removing whitespaces
If some whitespaces have been mistakenly introduced in your data, you can apply the Remove trailing and leading characters function to clean them.
There is still some work to do in the First_Name column, as well as the Last_Name column. Indeed, you can see striped boxes in front or behind some names.
To remove the whitespaces in the cells, proceed as follows:
Procedure
-
Click the header of the First_Name column to select its
content.
-
In the list of functions, click Remove trailing and leading
characters to open the options for the associated function.
-
In the Padding character drop-down list, select
whitespace and click Submit.
The striped boxes have disappeared from the cells in both columns.
