| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort by color: Is there an easy way to sort columns or rows in EX | Excel Worksheet Functions | |||
| Sort sheet based on particuilar sort order | Excel Worksheet Functions | |||
| sort function for dates does not sort properly in Office 2007 Exc. | Excel Worksheet Functions | |||
| data, sort option is grayed. how to sort on a column? | Excel Discussion (Misc queries) | |||
| Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
Linear Mode
