LinkBack URL
About LinkBacks
Want to be able to sort a column where all entries beginning with a 1 are sorted before all entries beginning with a 2, then 3, then 4, etc. regardless of the length.
999
1003
want the results to be
1003
999
Want to be able to sort a column where all entries beginning with a 1 are sorted before all entries beginning with a 2, then 3, then 4, etc. regardless of the length.
999
1003
want the results to be
1003
999
Hi mrp,
Can you share more data .. may be 5-6 numbers more.. to clarify this further.. Thanks.
what would be the result if you short :-
11
12
21
22
31
30
20
111
211
311
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
the resulting sort from your numbers would be
11
111
12
21
211
22
20
31
311
30
another example
1
111111
111211
111232
111555
111567
112211
112232
114789
114791
118450
118490
119020
119121
2
21
222
231789
232890
thanks
Format column as Text.
Or:
=TEXT(A1,"0")
=FIXED(A1,0)
Both of these will format with any decimal places. Change the 0 as required (e.g =TEXT(A1,"0.00") =FIXED(A1,2) will both give two decimal places).
=CONCATENATE(A1) will force the value in A1 to become text (in the result cell, I mean).
Last edited by GazP; 08-25-2012 at 07:36 AM. Reason: Remove double post
Concatenate gave me the exact results that I wanted.
Many thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks