sort

F

frans

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?
 
C

ChristopherTri

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...
 
F

frans

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.
 
Top