View Single Post
  #1   Report Post  
S.G.Pillai
 
Posts: n/a
Default Sort data in Excel

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