View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
apprentice idiot apprentice idiot is offline
external usenet poster
 
Posts: 8
Default SORT RIGHT-TO-LEFT IN EXCEL

I'd like to sort a row of columns wherein each cell would be sorted
alphabetically but in reverse order; i.e. a cell with the word MICROSOFT
would be sorted as "TFOSORCIM", and one with EXCEL would be sorted as "LECXE"
(This to get groupings of words by their endings: e.g., "-ment", "-ation",
"-ity", "-ship", etc.).