Let's assume the data is in A1..
Make a helper column B with formula in B1: ==MID(A1,5,255)
Sort on this
Remember the column can be hidden is needed
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Yossy" wrote in message
...
I have this

ABS
ABS_Canada
DCG_Netherland
HNK_France
HGP_Ontario
KLG_France
JKL_Canada

How do I sort using the country alphabetically. Where no country all data
should be lined up together beneath one another