View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dzuy
 
Posts: n/a
Default Sorting: Sorting by the First Character

I'm looking to sort my data by looking at the first character only. Here's an
example data set:

21
100
4020
56
32

I want this data set to look like this:

100
21
32
4020
56

I think it may require some programming, but I'm not sure. And I haven't the
slightest idea on how to program. Can anyone help shed some light on my
issue? Thanks!