Send to a Friend

ETpro's avatar

How do you sort columns of number/text mix in Excel?

Asked by ETpro (34605points) 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

Using Email

Separate multiple emails with commas.
We’ll only use these emails for this message.