Above each table column you can find the sorting symbol:

At mixtures of numbers and text, may be the sorting is not as desired. In the setting options under Extras menu -> Settings... -> Table -> Sort digits as numbers, you can determine the mode of sorting:

Option activated

For the sorting the value of the total number is considered, so that a natural sort happens.

Option deactivated

By default, the whole string is taken as text and so the leading number has higher priority than the total numerical value. See above figure.