This tool sorts the texts based on the order that the letters have in the English alphabet.Sort column B descending and column A ascending. The order is not affected by word positions that do not exist in any of the texts so it does not matter if 2-4 or 2-100 is used as long as none of the texts consist of more than 4 words. For example, 2-4 means that the list should be sorted by the words at position 2, 3 and 4. If the texts should be sorted by multiple word positions that comes after each other in a sequence it can be written as the lowest and highest word number with a hyphen ( -) between them. by comparing each letter from left to right in the whole text. If all the words at the listed positions are the same for some of the texts their internal order will be based on the default sorting procedure, i.e. The extra word positions will be used to decide the order when the words at the first word position are the same for two texts. It is possible to base the sorting on multiple words by entering a list of word positions, separated by spaces or commas. This can for instance be used to sort a list of people based on their surnames, even though the first and middle names comes before the surname in the text. You decide if the word positions should be counted from the left or from the right.

The first word has number 1, the second has number 2, and so on. To do this you first need to select the topmost checkbox ( Sort by word.) and fill in the word position that you want to sort by. It is also possible to sort the texts by words at specific positions.

For example, the word 'boat' is sorted before 'book' because a comes before o in the English alphabet. The first letters that differ between two texts decide which one of them should come first. The default sorting procedure is to compare each letter from left to right. If there is only one row the tool will first try to use semicolons ( ) to separate the items, but if there are no semicolons it will instead use commas ( ,).

If the text area contains multiple rows the tool will treat each row as a separate item. This tool makes it easy to sort a list of texts in alphabetical order.

Openoffice calc sort alphabetically