Sort help

  • Thread starter Thread starter Yossy
  • Start date Start date
Y

Yossy

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
 
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
 
Back
Top