SORTING CELLS CONTAINING TEXT AND NUMBERS

R

rapsgumbo

Why can't I get the number 10 to follow the number 9 when I sort? I keep
getting : STARGATE season 1-10
STARGATE season 10-10
STARGATE season 2-10
STARGATE season 3-10
STARGATE season 4-10
STARGATE season 5-10
STARGATE season 6-10
STARGATE season 7-10
STARGATE season 8-10
STARGATE season 9-10
This is part of my dvd inventory. What do I have to do? Each line of above
data is in one cell as in:
GENRE TITLE YEAR MINUTES
SCI-FI STARGATE SEASON 1-10 2006 871
 
A

akphidelt

First of all you own all 10 seasons of Stargate????

Second of all, excel considers that text and 1 comes before 2 regardless of
what comes after 1.

My best suggestion is to create a column that you can hide on the left side
of the data that numbers the seasons 1-10 then sort ascending by the numbers.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Updated Formula question 10
Find value based on two lookup values 2
Look up and count 1
a if calculation help 2
Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)??? 1
still having trouble with this formula 0
still having trouble with this formula 0
Numbers from first column 6

Top