Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Apr 2009
    Posts
    114
    Thanks
    18
    Thanked 0 Times in 0 Posts

    Sorting by Values and Text

    Hello
    I have a worksheet that contains values and text in the same cell that needs to be sorted by the value. For example the cell contains the entry 5 years 3 months and 10 days...I would like for it to sort by the value in the years. Any suggestions would be greatly appreciated!

    MOState

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Some options that come to my mind
    Add spaces or (zeroes) for leading values to differentiate the single digit years from ones over 9 and over 99

    Extract the year values into a new cell and sort on this column

    Extract/parse the entire "text" into a number and fraction of years and sort by this.

    If you have the values before converted to a year/month/day format, just sort on that value...

    Steve

    Steve

Posting Permissions

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