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