sort a range of numbers ignoring preceding letters

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

Guest

I have a range of reference IDs that are in the format:
AAA ###.### (eg ABC 123.456)
I wish to sort the range based only on the numbers in the ID (ignore any
text preceding the numbers).
I can use "text to columns" and then sort, but I was hoping there was an
easier way.
 
One way ..

Assuming data in A1 down

Put in B1: =MID(A1,SEARCH(" ",A1)+1,99)+0
Copy down

Then sort both cols A and B by col B
 
You must log in or register to reply here.

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

I am trying to write a macro using If...Then 1
Need to sort part numbers, sometimes ignoring leading letters 8
Sorting data bust ignoring numbers 3
Sorting data with the letter 'E' included 3
Numbers to sort as text 5
Sorting by rows with differing numbers of cell entries 3
Sort by column, not range 1
A question (sort of) 4

Back
Top