Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting contents from right to left
Do you know of a way to sort contents of a column from right to left? They
are formatted as text fields, even though their contents are numbers but they are not consistent lengths of numbers. Someone said I should change the language to Arabic or something? 12345 347 5443 7654 12 3452 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting contents from right to left
It would have helped, you know, if you had also shown how you would
expect them to be sorted. I assume that you want 12345 to be sorted as if it was 54321? If so, use the following formula next to your data (assuming start from A2). =SUMPRODUCT(MID(A2,ROW(INDIRECT("1:"&LEN(A2))), 1)*10^(ROW(INDIRECT("1:"&LEN(A2)))-1)) Sort by this column. HTH Kostis Vezerides On Jun 7, 3:31 pm, Kim wrote: Do you know of a way to sort contents of a column from right to left? They are formatted as text fields, even though their contents are numbers but they are not consistent lengths of numbers. Someone said I should change the language to Arabic or something? 12345 347 5443 7654 12 3452 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use 2nd digit from the left in cell contents for vlookup | Excel Worksheet Functions | |||
Sorting on partial Cell contents VBA | Excel Discussion (Misc queries) | |||
Sorting Right to Left | Excel Worksheet Functions | |||
sorting alpha numeric list by first left digit | New Users to Excel | |||
Sorting in reverse (from right-to-left and from top-to-bottom) | Excel Discussion (Misc queries) |