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 and
last_namecolumns contain some entries with blank spaces.
Procedure
-
Select the first_name column.
-
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 functions panel, type Remove trailing and leading
characters and click the result to open the options for the
associated function.
-
In the Padding character drop-down list, select
Whitespace and click Submit.
You have the possibility to output the result of this function in a new
column by selecting the Create new column check
box.
Results
Blank spaces are removed from the selected columns.
