hi all,
please help me with that sorting data not based on cell value but based on data order as shown in the following example.
Ex:
Original Data
28
25
287
289
2560
25620
2897
28899
257
257000
Sorted Data
25
2560
25620
257
257000
28
287
289
28899
2897
i want to sort the Original Data by comparing digits starting form left to right as show in the example (Sorted Data).
thanks,
Bookmarks