Page 1 of 2 12 LastLast
Results 1 to 16 of 17

Thread: Putting a list of numbers into order

  1. #1
    Senior Member
    Join Date
    Aug 2004
    Location
    W Yorkshire
    Posts
    5,691
    Thanks
    85
    Thanked
    15 times in 13 posts
    • XA04's system
      • Motherboard:
      • MSI X570-A Pro
      • CPU:
      • AMD Ryzen 5 3600
      • Memory:
      • Corsair 2x 8gb DDR 4 3200
      • Storage:
      • 1TB Serpent M.2 SSD & 4TB HDD
      • Graphics card(s):
      • Palit RTX 2060
      • PSU:
      • Antec Truepower 650W
      • Case:
      • Fractcal Meshify C
      • Operating System:
      • Windows 10
      • Monitor(s):
      • iiyama 34" Curved UWQHD
      • Internet:
      • Virgin 100mb Fibre

    Putting a list of numbers into order

    Hi,
    Basically polishing up some coursework for school, but I need to put a load of numbers into order (which are quite random atm)... is there a quick way of doing this? Preferbly in M$ Word.

    Would do it manually.. but there is TONS of numbers.

    Thanks!

  2. #2
    cat /dev/null streetster's Avatar
    Join Date
    Jul 2003
    Location
    London
    Posts
    4,138
    Thanks
    119
    Thanked
    100 times in 82 posts
    • streetster's system
      • Motherboard:
      • Asus P7P55D-E
      • CPU:
      • Intel i5 750 2.67 @ 4.0Ghz
      • Memory:
      • 4GB Corsair XMS DDR3
      • Storage:
      • 2x1TB Drives [RAID0]
      • Graphics card(s):
      • 2xSapphire HD 4870 512MB CrossFireX
      • PSU:
      • Corsair HX520W
      • Case:
      • Coolermaster Black Widow
      • Operating System:
      • Windows 7 x64
      • Monitor(s):
      • DELL U2311
      • Internet:
      • Virgin 50Mb
    pop them into excel and do tools->sort

  3. #3
    Senior Member
    Join Date
    Aug 2004
    Location
    W Yorkshire
    Posts
    5,691
    Thanks
    85
    Thanked
    15 times in 13 posts
    • XA04's system
      • Motherboard:
      • MSI X570-A Pro
      • CPU:
      • AMD Ryzen 5 3600
      • Memory:
      • Corsair 2x 8gb DDR 4 3200
      • Storage:
      • 1TB Serpent M.2 SSD & 4TB HDD
      • Graphics card(s):
      • Palit RTX 2060
      • PSU:
      • Antec Truepower 650W
      • Case:
      • Fractcal Meshify C
      • Operating System:
      • Windows 10
      • Monitor(s):
      • iiyama 34" Curved UWQHD
      • Internet:
      • Virgin 100mb Fibre
    I don't see anything under tools

    Edit: Nevermind, found it!. Data >> Sort...
    Can't seem to get it to work tho

    Fiddled with it and it looks like it's to sort multiple cells..
    Last edited by XA04; 27-03-2006 at 06:17 PM.

  4. #4
    HEXUS.social member Agent's Avatar
    Join Date
    Jul 2003
    Location
    Internet
    Posts
    19,185
    Thanks
    738
    Thanked
    1,609 times in 1,048 posts
    Seperate the data into different cells then
    There is even a wizard to do it
    Quote Originally Posted by Saracen View Post
    And by trying to force me to like small pants, they've alienated me.

  5. #5
    Senior Member
    Join Date
    Aug 2004
    Location
    W Yorkshire
    Posts
    5,691
    Thanks
    85
    Thanked
    15 times in 13 posts
    • XA04's system
      • Motherboard:
      • MSI X570-A Pro
      • CPU:
      • AMD Ryzen 5 3600
      • Memory:
      • Corsair 2x 8gb DDR 4 3200
      • Storage:
      • 1TB Serpent M.2 SSD & 4TB HDD
      • Graphics card(s):
      • Palit RTX 2060
      • PSU:
      • Antec Truepower 650W
      • Case:
      • Fractcal Meshify C
      • Operating System:
      • Windows 10
      • Monitor(s):
      • iiyama 34" Curved UWQHD
      • Internet:
      • Virgin 100mb Fibre
    Mind on telling me where to find the wizard?

    Edit: Found it, need to put spaces inbetween it all though >_<


    Thanks guys.
    Last edited by XA04; 27-03-2006 at 06:36 PM.

  6. #6
    HEXUS.social member Agent's Avatar
    Join Date
    Jul 2003
    Location
    Internet
    Posts
    19,185
    Thanks
    738
    Thanked
    1,609 times in 1,048 posts
    Whats the current separator in use ?
    You can define what you want to use iirc.
    Quote Originally Posted by Saracen View Post
    And by trying to force me to like small pants, they've alienated me.

  7. #7
    unapologetic apologist
    Join Date
    Nov 2005
    Location
    UK
    Posts
    1,954
    Thanks
    363
    Thanked
    274 times in 145 posts
    explain the spaces req. Am an excel guru.

    how many columns?

    if more than one, do you need to sort by a partic column?

    do you need to break up data into multiple pieces? - can use text functions to do so

    can also sort inside a word table, tho no real need

  8. #8
    Senior Member
    Join Date
    Dec 2005
    Location
    south of heaven
    Posts
    519
    Thanks
    0
    Thanked
    2 times in 2 posts
    cat numbers | sort -n

    SmoothNuts!~yaman_an@*.dsl.pipex.com > change my rating to exceptional tbh

  9. #9
    Senior Member
    Join Date
    Aug 2004
    Location
    W Yorkshire
    Posts
    5,691
    Thanks
    85
    Thanked
    15 times in 13 posts
    • XA04's system
      • Motherboard:
      • MSI X570-A Pro
      • CPU:
      • AMD Ryzen 5 3600
      • Memory:
      • Corsair 2x 8gb DDR 4 3200
      • Storage:
      • 1TB Serpent M.2 SSD & 4TB HDD
      • Graphics card(s):
      • Palit RTX 2060
      • PSU:
      • Antec Truepower 650W
      • Case:
      • Fractcal Meshify C
      • Operating System:
      • Windows 10
      • Monitor(s):
      • iiyama 34" Curved UWQHD
      • Internet:
      • Virgin 100mb Fibre
    Basically I've got the data in a stem and leaf diagram and need to put it into order.

    The way I'm doing at the moment is:

    Copy and Paste from M$ word to M$ Excel, In excel: Tools > Text to columns (go to options to change to rows) >> Fixed Width button >> Finish.

    Copy and paste into notepad (can't do it into word because of formatting), delete the spaces, then copy and paste again.


    I might as well do it by hand because this way is stupid and longer. DOING MY HEAD IN!

    That's just for one row, and I need to do a few for each diagram (and there is about 15 diagrams).

  10. #10
    unapologetic apologist
    Join Date
    Nov 2005
    Location
    UK
    Posts
    1,954
    Thanks
    363
    Thanked
    274 times in 145 posts
    those spaces, where are they?

    you can trim spaces from words by using the followin function:

    =TRIM(A1) assuming A1 is your first cell

    it will remove all spaces from either side of a word, unless in a phrase, in which case it will reduce them to one

    You can also then simply copy all the text and paste it over itself via EDIT / PASTE SPECIAL in excel and choose VALUES, if you don't want the formulas any more.

    if there are single spaces you want to remove from between 2 words (eg Pig Dog), then can use:

    =LEFT(A1,FIND(" ",A1)-1)&RIGHT(A1,LEN(A1)-FIND(" ",A1))

    could then do that copy/paste special/ values again if you wanted

    shouldn't be any need to go to Notepad.

    also, you can swop data from rows to columns by copying it, then PASTE SPECIAL / TRANSPOSE

    gimme more info if need be

  11. #11
    unapologetic apologist
    Join Date
    Nov 2005
    Location
    UK
    Posts
    1,954
    Thanks
    363
    Thanked
    274 times in 145 posts
    ok, had a look at a stem and leaf (before my time - lol)

    can't you just copy the text out of Word, paste into Excel, and click the A-Z button?

    then copy/paste back?

    what do they use to separate the stem from the leaf - a character or a drawn line or a table?

    if it's a Word table, you can just turn on the TABLES AND BORDERS toolbar, and use the simple sorting tools there, too. click in the req column and off you go


  12. #12
    Senior Member
    Join Date
    Aug 2004
    Location
    W Yorkshire
    Posts
    5,691
    Thanks
    85
    Thanked
    15 times in 13 posts
    • XA04's system
      • Motherboard:
      • MSI X570-A Pro
      • CPU:
      • AMD Ryzen 5 3600
      • Memory:
      • Corsair 2x 8gb DDR 4 3200
      • Storage:
      • 1TB Serpent M.2 SSD & 4TB HDD
      • Graphics card(s):
      • Palit RTX 2060
      • PSU:
      • Antec Truepower 650W
      • Case:
      • Fractcal Meshify C
      • Operating System:
      • Windows 10
      • Monitor(s):
      • iiyama 34" Curved UWQHD
      • Internet:
      • Virgin 100mb Fibre
    I've used a table in M$ word to make the stem and leaf diagram.

    It basically looks like this:


    5|0 1 2 8 4 1 4 6
    6|1 2 3 9 1 1

    6|1 meaning 61.

    So, I have to change it into order, so the row 5 would look like:
    5| 0 1 1 2 4 4 6 8


    I'm going to begin to do it manually by hand now, will take a while but need it in for tomorrow. Is there an easy way of doing this?

    Sorry for any confusion anyone.

    Site note: I have made the table in M$ word with two columns, first column is for the 5| and second for the 0 1 1 2... (the pipe symbol doesn't *actually* exist, it's just border colouring).

  13. #13
    unapologetic apologist
    Join Date
    Nov 2005
    Location
    UK
    Posts
    1,954
    Thanks
    363
    Thanked
    274 times in 145 posts
    gotcha!

    ok, now I understand (doh!)

    still as easy as pie:

    1) paste it into Excel, dividing it by fixed width via the wizard

    2) highlight just the area you want to sort - the specific leaf

    3) DATA / SORT

    4) it will ask if you want to continue with selection - YES

    5) click on OPTIONS

    6) choose LEFT TO RIGHT

    7) bob's ya auntie

    you could even record it as a Relative Macro so that a simple click of a button would do the entire process of both Text To Columns & sorting



    when you paste it back into word, paste as table then remove certain borders with the eraser, or paste as plain text then use the TEXT TO TABLE tool to rebuild the table as you like, etc.
    or even paste as a picture and muck around with that

    Last edited by fuddam; 27-03-2006 at 10:08 PM.

  14. #14
    Senior Member
    Join Date
    Aug 2004
    Location
    W Yorkshire
    Posts
    5,691
    Thanks
    85
    Thanked
    15 times in 13 posts
    • XA04's system
      • Motherboard:
      • MSI X570-A Pro
      • CPU:
      • AMD Ryzen 5 3600
      • Memory:
      • Corsair 2x 8gb DDR 4 3200
      • Storage:
      • 1TB Serpent M.2 SSD & 4TB HDD
      • Graphics card(s):
      • Palit RTX 2060
      • PSU:
      • Antec Truepower 650W
      • Case:
      • Fractcal Meshify C
      • Operating System:
      • Windows 10
      • Monitor(s):
      • iiyama 34" Curved UWQHD
      • Internet:
      • Virgin 100mb Fibre
    Thanks. Pretty much what I said I was doing before though (post #9) - and there is still the problem with the spacing if I copy and paste it into notepad - or problem with tables if i copy and paste into word.

    Got a high D in this coursework... but the teacher said since I've done so much with it I only need to add a few other little small bits to get it upto a B .


    Cheers.
    Last edited by XA04; 27-03-2006 at 10:36 PM.

  15. #15
    unapologetic apologist
    Join Date
    Nov 2005
    Location
    UK
    Posts
    1,954
    Thanks
    363
    Thanked
    274 times in 145 posts
    lol

    if you paste it into word from excel as UNFORMATTED TEXT, you can do FIND AND REPLACE to find all the tabs and replace them with single spaces

    would do that at the end, since would do them all in one go

    resulting data can then be coverted into a table/s

    am pretty much trying to avoid doing my own work, methinks - proctrastinator deluxe

  16. #16
    Senior Member
    Join Date
    Aug 2004
    Location
    W Yorkshire
    Posts
    5,691
    Thanks
    85
    Thanked
    15 times in 13 posts
    • XA04's system
      • Motherboard:
      • MSI X570-A Pro
      • CPU:
      • AMD Ryzen 5 3600
      • Memory:
      • Corsair 2x 8gb DDR 4 3200
      • Storage:
      • 1TB Serpent M.2 SSD & 4TB HDD
      • Graphics card(s):
      • Palit RTX 2060
      • PSU:
      • Antec Truepower 650W
      • Case:
      • Fractcal Meshify C
      • Operating System:
      • Windows 10
      • Monitor(s):
      • iiyama 34" Curved UWQHD
      • Internet:
      • Virgin 100mb Fibre
    How can you paste without formatting? (What I've been doing is pasting to notepad then into word)

    And I don't think (or know) how to search for tabs.

    Edit: Nevermind, can copy a tab into there... bloody too much trouble tbh.
    Last edited by XA04; 27-03-2006 at 10:52 PM.

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Scan has [b]b0rked[/b] my order.
    By SilentDeath in forum SCAN.care@HEXUS
    Replies: 10
    Last Post: 21-01-2005, 01:43 AM
  2. Eatay order
    By Michael in forum General Discussion
    Replies: 3
    Last Post: 28-12-2004, 12:01 AM
  3. My video card order nightmare has ended!
    By myth in forum General Discussion
    Replies: 2
    Last Post: 06-11-2004, 05:05 PM
  4. Non-Geographical Alternative Telephone Numbers
    By silentphoenix in forum Retail Therapy and Bargains
    Replies: 6
    Last Post: 01-02-2004, 04:04 PM
  5. Free Clothes ! With Vouchers
    By Scooby in forum Retail Therapy and Bargains
    Replies: 132
    Last Post: 16-01-2004, 11:26 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •