View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
serendipity258 serendipity258 is offline
external usenet poster
 
Posts: 2
Default Sort by number only in cell

I have files with a bunch of cells with mixed number/text information. I
would like to sort by the number only.

Each cell contains a 1-3 digit number, and 0-2 letters in some combination
of prefix and suffix.

For example, a list might be:
3
A100C
A100D
AB205
B4
53DE

And I would like it sorted by the number only. Actually, I would like it
sorted by the number, then the suffix, then the prefix, but the number is a
big step in that direction...

Thank you :)