First Part - Remove
To access First Part Commands just checked on Remove CheckBox. You will see 12 useful command in Dropdown Menu. We can devide these commands in 2 categorie. One is Multiple Columns Command, Second is Single Column Commands.

Following Commands can be applied on Multiple Column Selection:

Following Commands can be applied on Single Column Selection:

10. Duplicate Values - Keep One
Using this command you can remove all duplicates except the first one in a single column selection.

Some Example with Simple Start Position

Remove All Characters After nth Character
If you want to remove all characters after 2nd Character. Just check on all Characters, enter 2 in Start Position (SP) textbox and click on After(SP)
Example : [Example One Two 1 2] to [Ex]

Remove all characters after 1st Space
If you want to remove all characters after 1st Space. Check on All characters and check on Select Position and Choose '1st', Choose 'Space' from Select Character Dropdown menu and click on After(SP).

Example : [Example One Two 1 2 3] to [Example ]

Remove all characters before Last Space
If you want to remove all characters before Last Space. Check on All characters and check on Select Position and Choose 'Last, Choose 'Space' from Select Character Dropdown menu and click on Before(SP).

Example : [Example One Two 1 2 3] to [ 3]

Remove x no. of characters with User-defined condition
If you want to remove 4 Characters before 5th Space. Check off All characters and type 4 in white textbox check on Select Position and type 5 in Select Postion, Choose 'Space' from Select Character Dropdown menu and click on Before(SP).

Example : [Example One Two 1 2 3] to [Example One Two 3]

Note : You can also customize Conditional Start Postion with your own Criterial. Just type Position No. in Select Position and Type the Character. It is not neccessary that character & position should be from the List. You can type your own.