Sort help
 

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
HGB_KLLLMM_Spain
GBN_KNL_NMT_Netherland
VBT_HNJ_MVT_France
BBBBVV_JJNNH_Spain
HNK_France
HGP_Ontario
KLG_France
JKL_Canada

Thanks
All help totally appreciated

Sort help
 

Please refrain from multiposting

--


Regards,


Peo Sjoblom

"Yossy" wrote in message
...
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
HGB_KLLLMM_Spain
GBN_KNL_NMT_Netherland
VBT_HNJ_MVT_France
BBBBVV_JJNNH_Spain
HNK_France
HGP_Ontario
KLG_France
JKL_Canada

Thanks
All help totally appreciated

Sort help
 

Hi,

You need a helper column. Put this in B1 and drag down

=RIGHT(A1,LEN(A1)-SEARCH("@",SUBSTITUTE(A1,"_","@",LEN(A1)-LEN(SUBSTITUTE(A1,"_","")))))

Select column A & B and sort on column B. Ensure 'No Header' is selected in
the sort dialog box.

When sorted you can delete or hide column B

Mike

"Yossy" wrote:

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
HGB_KLLLMM_Spain
GBN_KNL_NMT_Netherland
VBT_HNJ_MVT_France
BBBBVV_JJNNH_Spain
HNK_France
HGP_Ontario
KLG_France
JKL_Canada

Thanks
All help totally appreciated