sorting columns

D

dean d.

i want to srt a column in the following order a-1,a-2,a-3 and so on. as of
now excel is sorting a-1 ,a-10 a-11 and so on
 
P

Peo Sjoblom

You would need a help column for that, if the numbers are always after the
hyphen then you could use

=--TRIM(MID(A2,FIND("-",A2)+1,255))


copy down then sort ascending on the help column


--


Regards,


Peo Sjoblom
 

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

Linking Child Timelines to Multiple Parents 0
List all tables, including document structure 0
Finding the proper style field and the numbered paragraph value within the style 0
Merging from an Excel file with graphics 1
Finding the right style field in VBA 0
Cannot sort a table containing text 5
excel 2011 won't sort alphabetically 7
Keep First Letters, with exceptions 0

Top