How to sort alphabetically with German umlauts (Ä, Ö, Ü)?

I want to sort a list with Names, but all names with umlauts (Ä, Ö, Ü) then appear an the bottom. Can I change the settings so that it sorts correctly (Ö will appear as Oe, etc...)?


Would be great when someone has a solution for my problem. Thanks in advance!


Julian

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    The only thing I can think of would be to use a helper column with a nested SUBSTITUTE function to swap out the umlauts with their equivalent for sorting.

    =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE([email protected], "Ö", "Oe"), "Ä", "value"), "Ü", "value")


    You can hide this helper column to keep the sheet looking clean but still sort on it even when it is hidden.

    thinkspi.com

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    The only thing I can think of would be to use a helper column with a nested SUBSTITUTE function to swap out the umlauts with their equivalent for sorting.

    =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE([email protected], "Ö", "Oe"), "Ä", "value"), "Ü", "value")


    You can hide this helper column to keep the sheet looking clean but still sort on it even when it is hidden.

    thinkspi.com

  • thanks, Paul! Great idea😀

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Happy to help. 👍️

    thinkspi.com