how can I sort alphanumeric entries by number in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to sort a column of alphanumic numbers in EXCEL with it ignoring the
prefix letters.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

alphanumeric sorting 1
Autofill alphanumeric prefix in Excel 2
how to do data validation in excel 1
Highest alphanumeric 6
Excel 4 characters alphanumeric data validation check on one excel column. 1
Alphanumeric limitation 11
sorting by name 6
automated cut and paste using regex 2

Back
Top