Forum Discussion
data filter and pivot table manipulate data
With the following formula, you can use a workaround. As far as I know, you cannot make pivot tables case sensitive.
Each capital letter is marked with a 0-wide space (unichar 8203).
=TEXTJOIN("",TRUE,IF(UNICODE(MID(B2,SEQUENCE(LEN(B2)),1))>64,IF(UNICODE(MID(B2,SEQUENCE(LEN(B2)),1))<91,UNICHAR(8203),""),"")&MID(B2,SEQUENCE(LEN(B2)),1))So you don't see that at all. Pivot will still differentiate according to whether it is present.
Ich hoffe das hilft dir weiter.
With the following formula, you can use a workaround. As far as I know, you cannot make pivot tables case sensitive.
Each capital letter is marked with a 0-wide space (unichar 8203).
=TEXTJOIN("",TRUE,IF(UNICODE(MID(B2,SEQUENCE(LEN(B2)),1))>64,IF(UNICODE(MID(B2,SEQUENCE(LEN(B2)),1))<91,UNICHAR(8203),""),"")&MID(B2,SEQUENCE(LEN(B2)),1))So you don't see that at all. Pivot will still differentiate according to whether it is present.
Ich hoffe das hilft dir weiter.
Thank you for your interesting feedback.
Your solution is not the first thing that comes to mind, but it is an elegant solution to my problem.
It would certainly be better if there was a switch in Excel or Pivot for case sensitivity. That is my request for improvement to Microsoft.
Thanks again for your efforts!
