Send to a Friend
How do you sort columns of number/text mix in Excel?
Asked by ETpro (34605)
June 21st, 2011
If I have a colum of data of a for usch as “example-1, example-2” and I sort it, it doesn’t come out in proper order. Instead, it looks like:
example-1
example-10
example-11
example-12
example-13
example-14
example-15
example-16
example-17
example-18
example-19
example-2
example-20
example-3
example-4
example-5
example-6
example-7
example-8
example-9
Assuming the text in place of “Example” is the same for every row, how can you set the Category of the cells or modify the sort so this column sorts in what humans would consider numerical order?
Using Fluther
or