Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort
I need to sort columns that contain both letters & digits.
Example: ab3 ab13 ab1 Would sort like: ab1 ab13 ab3 When I want to sort like: ab1 ab3 ab13 Is there a way to do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort
Try splitting the column into two columns, one that contains the text and one
that contains the numbers using the "Text to Columns" function in the data menu. Use the standard sort feature to sort the text colunm in the first field and the data colunm in the second. Finally, you can recombine the columns using the CONCANTENATE function. Regards... "frans" wrote: I need to sort columns that contain both letters & digits. Example: ab3 ab13 ab1 Would sort like: ab1 ab13 ab3 When I want to sort like: ab1 ab3 ab13 Is there a way to do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort
Christopher,
Thanks for the help. This does work however, whatever I choose to separate the column on I lose. Example: I split the column on "b" Then I get a column with a and one with the number but the b is gone: a 13 Is there a way to prevent this? Thanks. "ChristopherTri" wrote: Try splitting the column into two columns, one that contains the text and one that contains the numbers using the "Text to Columns" function in the data menu. Use the standard sort feature to sort the text colunm in the first field and the data colunm in the second. Finally, you can recombine the columns using the CONCANTENATE function. Regards... "frans" wrote: I need to sort columns that contain both letters & digits. Example: ab3 ab13 ab1 Would sort like: ab1 ab13 ab3 When I want to sort like: ab1 ab3 ab13 Is there a way to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to sort on data field | Excel Discussion (Misc queries) | |||
how to sort anything that looks like a number as a number | Excel Discussion (Misc queries) | |||
Saving Sort Criteria (or Sort Lists) | Excel Worksheet Functions | |||
Select rows and sort based on type | Excel Discussion (Misc queries) | |||
"-" ignored in sort | Excel Discussion (Misc queries) |