How to sort - Help

[Yossy]

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

 

[Bernard Liengme]

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

 

[Yossy]

this doesn't help, some of my values are cut off. Please How do I sort using
the country alphabetically. Where no country all data should be lined up
together beneath one another

ABS
ABS_Canada
GBP_JKL_Spain
DCG_Netherland
HNK_France
HGP_Ontario
KLG_France
JKL_Canada

 

[Bernard Liengme]

So your examples were not all inclusive? The number of letters before the
dash is not always 3 as you show?
Then use
=IF(ISNUMBER(FIND("-",A1,1)), MID(A1,FIND("-",A1,1)+1,255),A1)
best wishes