Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Discussion (Misc queries) > SORTING CELLS CONTAINING TEXT AND NUMBERS
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 2
Default SORTING CELLS CONTAINING TEXT AND NUMBERS
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


Reply With QuoteReply With Quote
  #2   Report Post  
Member
  
Posts: 58
Default
Quote:
Originally Posted by rapsgumbo View Post
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
rapsgumbo:

Type "Default sort orders" in the help box will explain this.
Reply With QuoteReply With Quote
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 461
Default SORTING CELLS CONTAINING TEXT AND NUMBERS
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.

"rapsgumbo" wrote:

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


Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Hybrid Mode Hybrid Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting cells that have both Text and Numbers CherylH Excel Discussion (Misc queries) 1 September 4th 07 06:51 PM
Sorting (Numbers with Text) JSpence2003 Excel Discussion (Misc queries) 8 August 31st 07 10:30 PM
Sorting cells with Combined Text and Numbers daj Excel Discussion (Misc queries) 0 August 8th 07 09:36 PM
Sorting - cells containing numbers, numbers and letters Gunny Excel Discussion (Misc queries) 5 July 16th 06 01:22 AM
SORTING TEXT AND NUMBERS jstephenson Excel Worksheet Functions 5 February 10th 06 08:44 PM


All times are GMT +1. The time now is 04:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement