Re: [users] How to sort mixed alpha & numbers?

Two possibilities come to mind -- 1. Put the text in one column and the number in the next. 2. Pad the numbers with leading 0's so all the numbers have the same number of characters USA 00084 USA 00604 USA 00275 USA 35024 USA 00103 USA 00116 USA 38747 USA 00072 USA 00040 USA 87549 USA 41001 U

Re: [users] How to sort mixed alpha & numbers?

At 20:35 09/09/2009 -0700, Gary Noop wrote: I've tried every combination that I can think of (even formating cells to text) and still cannot figure out how to sort via a column with data like this: Sail Number USA 84 USA 604 USA 275 USA 35024 USA 103 USA 116 USA 38747 USA 72 USA 40 USA 87549 U

[users] How to sort mixed alpha & numbers?

I've tried every combination that I can think of (even formating cells to text) and still cannot figure out how to sort via a column with data like this: Sail Number USA 84 USA 604 USA 275 USA 35024 USA 103 USA 116 USA 38747 USA 72 USA 40 USA 87549 USA 41001 USA 52 USA 28719 Any suggestions? --