Given

A list of 12 street names in different notations (column ORIGNALSCHREIBWEISE)

Problem I – Filter

Adding a filter and opening the dropdown list shows a reduced number (9 of 12) of ORIGNALSCHREIBWEISE-entries with standardised notations:

Problem II – pivot table

Creating a pivot table from the list the result is the same as in the filter drop down list: the number of notations is reduce to 9:

Error Interpretation

In both test cases Excel doesn’t work case sensitiv. It interprets

Sankt-Martin-str. / Sankt-Martin-Str.St.-martin-Str. / St.-Martin-Str.St.-Martin-straße / St.-Martin-Straße

as identical strings.

Question

How can I force Excel to work in both cases case sensitive?

​GivenA list of 12 street names in different notations (column ORIGNALSCHREIBWEISE) Problem I – FilterAdding a filter and opening the dropdown list shows a reduced number (9 of 12) of ORIGNALSCHREIBWEISE-entries with standardised notations: Problem II – pivot tableCreating a pivot table from the list the result is the same as in the filter drop down list: the number of notations is reduce to 9: Error InterpretationIn both test cases Excel doesn’t work case sensitiv. It interpretsSankt-Martin-str. / Sankt-Martin-Str.St.-martin-Str. / St.-Martin-Str.St.-Martin-straße / St.-Martin-Straßeas identical strings.QuestionHow can I force Excel to work in both cases case sensitive?     Read More

​