Sorting problem
Sorting problem

I have a problem sorting when the data is a mix of numbers and text.
my data is a number with some text after it. like this "100 apples"
my table is sorted like this
100 apples
444 apples
8 apples
99 apples
and not like this
444 apples
100 apples
99 apples
8 apples
my data is a number with some text after it. like this "100 apples"
my table is sorted like this
100 apples
444 apples
8 apples
99 apples
and not like this
444 apples
100 apples
99 apples
8 apples
This discussion has been closed.