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:
 

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

Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0
Word- Find and Replace 1
Help with multi-level list 0
Creating Different Headers in Word 0
vlookup using date ranges 0
parameter query needed 7
List all tables, including document structure 0

Top