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