LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Joanne
 
Posts: n/a
Default sorting an alphanumeric list - please someone help!

I posted this yesterday and got no responses. Is there someone who could
help me?
_____________________________________________
would like to sort some text which is formatted in column one as:
1'
100
1000'
2
2'
and so on. Any number that does not have an "'" at the end should come
before any number that does and all the 1s, 2s, 3s, etc. should be grouped
together. Is this possible? The result would look like:
1
100
1000'
2
2'

Boy, would I appreciate some help
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 alphanumeric Joanne Excel Discussion (Misc queries) 3 April 28th 05 10:07 PM
Sorting List of Numbers Rowf Excel Discussion (Misc queries) 4 March 8th 05 08:29 PM
Does font color affect sorting a list in Excel? Valser Excel Worksheet Functions 2 February 27th 05 07:03 PM
Sorting for specific words/numbers in a list Heyna Excel Worksheet Functions 1 November 15th 04 07:59 PM
Sorting a list with subtotals Matt B. Excel Worksheet Functions 2 October 29th 04 01:19 PM


All times are GMT +1. The time now is 09:33 AM.

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"