Removing whitespaces
Last updated: 9/10/2026If 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.
-
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.
