+ Reply to Thread
Results 1 to 7 of 7

sort numbers in numeric form in a cell and down the rows

  1. #1
    Registered User
    Join Date
    09-07-2012
    Location
    perth, australia
    MS-Off Ver
    Excel 2010
    Posts
    29

    sort numbers in numeric form in a cell and down the rows

    hi all

    i have random numbers in a cell that need to sort in a numeric 1-100 form

    eg. 1 4 8 20 37 56 9 81 12 11 23 40(all this in one cell) there thousands of cell in a row need to be rearrange

    and the when this done i want to sort them in a 1 2 3 -100 form aswell

    eg. 1 2 3 4 5 6 10 11 12 13 14
    1 2 3 4 5 6 10 11 12 13 15
    1 2 3 4 5 6 10 11 12 13 16

    at the moment excel sort it as smallest to largest, end up like:

    1 10 ..........
    1 11........
    1 2...........

    kind regards

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,935

    Re: sort numbers in numeric form in a cell and down the rows

    To Attach a File:

    1. Click on Go Advanced
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    09-07-2012
    Location
    perth, australia
    MS-Off Ver
    Excel 2010
    Posts
    29

    Re: sort numbers in numeric form in a cell and down the rows

    hi, i hope the worksheet explain my problem better

    as you can see the number in each cell are not in sequential order, can you help me putting them in 1-100 order?

    kind regards
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,935

    Re: sort numbers in numeric form in a cell and down the rows

    Please Login or Register  to view this content.
    Copy the Excel VBA code
    Select the workbook in which you want to store the Excel VBA code
    Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
    Choose Insert | Module
    Where the cursor is flashing, choose Edit | Paste

    To run the Excel VBA code:
    Choose Tools | Macro | Macros
    Select a macro in the list, and click the Run button

  5. #5
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,935

    Re: sort numbers in numeric form in a cell and down the rows

    Deleted - double posted
    Last edited by protonLeah; 11-25-2012 at 03:29 PM. Reason: duplicate post by server

  6. #6
    Registered User
    Join Date
    09-07-2012
    Location
    perth, australia
    MS-Off Ver
    Excel 2010
    Posts
    29

    Re: sort numbers in numeric form in a cell and down the rows

    cheers, will let you know soon

  7. #7
    Registered User
    Join Date
    09-07-2012
    Location
    perth, australia
    MS-Off Ver
    Excel 2010
    Posts
    29

    Re: sort numbers in numeric form in a cell and down the rows

    hi protonLeah, i've tested your macro, unfortunately is not how i want it

    but probably because i didn't explain how i want clear (English still a second language for me)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1