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:
- Click the header of the FIRST_NAME column to select its
- In the list of suggested functions, click Remove Whitespaces
(Trailing and Leading).
The white boxes have disappeared from the cells in that column.
- Repeat those two steps on the LAST_NAME column.