If some whitespaces have been mistakenly introduced in your data, you can apply
the Remove Whitespaces 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 white 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.
-
While keeping the
Ctrl
button
pressed, click the header of the Last_Name column.
The two columns are now selected, and you can apply a function to both
columns in one action.
-
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 white boxes have disappeared from the cells in both columns.