View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default how can I sort alphanumeric entries by number in excel

Create a new column and extract the digits from the other cell. Then sort by
that column.

If your data looks like:
XX####
(always two alphas followed by the numbers)
it might be as simple as:

=--mid(A1,3,255)

Other formulas would depend on what your data looks like. You may want to post
a representative sample.

beasleyb wrote:

I need to sort a column of alphanumic numbers in EXCEL with it ignoring the
prefix letters.


--

Dave Peterson