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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"j0hnt52" wrote in message
...
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.