Share via

Microsoft Excel sort & filter alphanumeric data

Anonymous
2020-04-13T22:20:38+00:00

I have a list of record identifiers that are alphanumeric e.g. CVR01 to CVR3000.

I want to:

  1. Sort them so that they appear in numerical order. At the moment they are being sorted as follows: CVR09, CVR10, CVR100 etc.
  2. Is there a quick way to filter out a range of data records e.g. if I wanted to filter only records CVR250 to CVR300 how can I do that without manually having to tick and untick the relevant records on a standard filter?

Regards

Rajiv

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2020-04-14T02:54:57+00:00

    Hi Rajiv.Shah,

    Assume the alphanumeric are listed in clolumn A, inset follwoing formula into B1 and drag down.   

    =(RIGHT(A1,LEN(A1)-3))

    Click Sort & Filter button > A to Z

    Add filter, click Text filters > Begins with 

    Regards,

    Eric

    4 people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-04-14T01:29:47+00:00

    Excel 365 Pro Plus with Power Query.

    With lots of alphanumeric filter/sort/aggregate options.

    No formulas, no VBA macro.

    http://www.mediafire.com/file/5ct9taqruqfjy1c/04_13_20.xlsx/file

    http://www.mediafire.com/file/71ndrp1e57d0ykd/04_13_20.pdf/file

    0 comments
  2. Anonymous
    2020-04-15T04:45:30+00:00

    Hi,

    If you need more help, you can post your latest condition, 

    Regards,

    Eric

    1 person found this answer helpful.
    0 comments