|
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! |
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! |
| All times are GMT +1. The time now is 07:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com