Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: data sorting problem

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a large list of file reference numbers in the form 12/34/56789, which I need to sort by the last 2 digits only. Unfortunately each number is confined to a single cell. Rather than transfer by hand to a separate cell is there any way to isolate and sort the numbers I'm interested in? A further complication is that initial zeros are omitted: ie 12/34/(000)89, so the numbers are of varying length.

    philip

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    Place this formula in an un-used column:

    For example:

    Your "12/34/56789" numbers are in column A
    beginning at row 2 and going to row 2000

    Place this in an unused column in row 2:

    =Right(A2,2)

    Copy the formula down to row 2000
    Now sort using the new column as the key.

    Tom

    [ This Message was edited by: TsTom on 2002-04-25 04:46 ]

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    fast response Tom, thanks. I knew about delimiting but that wouldn't have done the whole job here. you've saved me and my co-workers quite a bit of time.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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