I have a column of real estate case identifiers in a spreadsheet. The format of the case id's can differ, but they all mix numeric and alpha characters. A sample column of id's might look like the following:
As a first step, I want to eliminate the alpha characters from each id and then sort the list as numbers. Any ideas?