View Single Post
  #2   Report Post  
Nick Hodge
 
Posts: n/a
Default

Can you use an extra column and sort by that, eg. if the tags are in column
A

=LEFT(A2,1)

This will parse the first letter into a new column and you can use this as
the first sort and then the original one as the second source

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"S.G.Pillai" wrote in message
...
I am having some tag numbers and it is entered in random. I want to sort
this
according to the group which starts alphabetically. How can this be done?
I
know that filter is one way but it doest work the way i want. Eg. I am
having
tags pg-1, , pg-5, pg-2, he-1, xza-2, pza-3, fia-1 etc. I want to sort it
such a way that all the tag starts with p should come together and h
should
come together .... and so on ..
how can this be done .
thanks in advance