sort number with fractions

S

surveyer

How can i sort this 1/1 1/2 10 191/2 2 201 202/5 280 3 3/2 to this 1/1 1/2 2
3 3/2 10 191/2 201 202/5 280? Please help!
 
S

Stefi

If you have these values in column T from T1 down then enter formula
=VALUE(LEFT(T1,IF(ISERROR(SEARCH("/",T1)),LEN(T1),SEARCH("/",T1)-1)))
in U1, select range T1:U10
and sort selection by column U (choose no header)!

Regards,
Stefi

„surveyer†ezt írta:
 
Top