| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting
I'm triying to sort letters and numbers together like ch5600,ch74110 and so on
but when I try it doesn't sort in scending sequence ch441 ch445 ch5416 ch5419 ch5429 ch5689 ch74110 ch76129 ch7848 ch7895 ch878 ch8833 ch8965 ch878 should be after ch445 and ch74110 and ch76129 should be the last numbers can you helpme wih this please (1 COLUMN) THANK YOU! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sorting
One way is to sort by a helper col
Assuming source data as posted in A1 down Place in B1, copy down: =MID(A1,SEARCH("ch",A1)+2,99)+0 Then select cols A & B, sort by col B Ascending OK -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "eurozeus" wrote: I'm triying to sort letters and numbers together like ch5600,ch74110 and so on but when I try it doesn't sort in scending sequence ch441 ch445 ch5416 ch5419 ch5429 ch5689 ch74110 ch76129 ch7848 ch7895 ch878 ch8833 ch8965 ch878 should be after ch445 and ch74110 and ch76129 should be the last numbers can you helpme wih this please (1 COLUMN) THANK YOU! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
| Sorting: Sorting by the First Character | Excel Discussion (Misc queries) | |||
| Sorting 1st, 2nd, 3rd... | Excel Discussion (Misc queries) | |||
| Sorting | Excel Worksheet Functions | |||
| Sorting | Excel Worksheet Functions | |||
Hybrid Mode
