Thread: sort
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
ChristopherTri ChristopherTri is offline
external usenet poster
 
Posts: 49
Default 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?