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
|