In a column next to your data, enter:On 2002-05-08 11:15, chouston wrote:
anyone know how I can sort this mess...
e.g.
a101
----
aprt
a102
b103
>>>>
a103
c201
====
c203
build
I want to sort to this:
a101
a102
a103
b103
c201
c203
I don't think isnumeric will work for me...I'm really stuck with this one!
Any help greatly appreciated!
=ISNUMBER(RIGHT(A1)+0)+0
and copy down.
Then sort on the second column descending then the first column ascending.
Like this thread? Share it with others