Formula Sorting Help

S

srparker

Is there a way to sort data by sub-fields?

Ex
Given my Cells look like:

A10.1234

I would like to sort by everything to the right of the decimal
(i.e. 1234)

Is there a smart way of doing this?
 
K

Ken Wright

With your data in Col A, starting in A1, in B1 put the following:-

=MID(A1,FIND(".",A1)+1,LEN(A1))

and then copy down. Select both Col A and B and sort on B.
 
S

srparker

Sweet!!

Thanks so much for the help!

One more quick question:

Can Excel allow you to sort data across several worksheets?

Thanks again Ken!
 
K

Ken Wright

Not by using any of the standard features, though one of the others may have a
macro to do this, but I haven't seen one that I recall I'm afraid.
 
Top