1. Select the columns to clean
The module will act on all values in one or several columns.
2. Set up optional parameters
Set up how to handle spaces in values by selecting one of these options:
Trim around values(default) to remove leading and trailing spaces in each cells
Trim before valuesto remove leading spaces in each cell
Trim after valuesto remove trailing spaces in each cell
Remove all spaceto remove leading and trailing spaces, as well as any other space within the value. For example
United Stateswill become
Condense spacesto remove any extra space within the value, and keep 1. For example
Great Britainwill become
Choose the way you want to capitalize values by selecting one of these options:
Leave as is(default) to keep the current capitalization
Uppercaseto make all letters in the cell a capital letter. For example,
THIS IS UPPERCASE.
Lowercaseto make all letters in the cell a lowercase letter. For example,
this is lowercase.
Use the first menu to choose if you want to
drop any of the following character categories, by checking the corresponding checkbox:
Customcan be used to enter a specific selection of characters. Type in the characters you want to target without any space or separators. For example if you want to act on
^, type in