View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Norman Jones
 
Posts: n/a
Default Sorting a subscription list

Hi Martin,

Now if someone can figure a way
that allows for the different letters we might have something useful


B1: =LEFT(A1,1)
C1: =--MID(A1,2,2)

Now Sort by Col B (asc) and Col C (asc)


---
Regards,
Norman



"MartinW" wrote in message
...
Hi Marzban,

You could use a helper column, assuming your S1, S10 etc. are in A1 down,
in B1 put =VALUE(MID(A1,2,3)) and copy down as far as your last
value then use sort ascending on column B.

The formula will work for your entire data but you will have to do a
seperate
sort for each letter of the alphabet. Now if someone can figure a way
that allows for the different letters we might have something useful.

HTH
Martin