Tidy

You simply tick the columns you wish to adjust, choose the tidy functions to apply and then click Run.

Casing

Will manipulate the upper and lower case letters of your data according to each options set of rules, which are as follows:

White Space

Trim Leading removes any white space at the start of a column, Trim Trailing removes white space from the end of a column and Compact Inner removes any white space between the first non white space character and the last one e.g.

...a test string... becomes ...ateststring...

Where the red dots represent leading and trailing white space.

Line Breaks

Clicking Replace with will convert any line break markers in the cells with the value you enter in the box below. Leaving this box empty will remove the markers altogether.