Office Excel 2016 , Filter Language Problem

Question

Hi,

I am using office excel 2016, I am feeding data in HINDI , while applying filter, the list is not showing in Hindi . 

Answer 1

Hi Dheeraj,

Welcome and thank you for posting your query in Microsoft Office Community.

Please provide us more information:

1. Are you facing this issue with a specific file or all Excel files?
2. Are you using Pivot table to sort out the data?

Please post to us with the required information to help you better.

Thank you.

Answer 2

Hello Dheeraj,

We had our engineering folks take a look at this and the problem seems to be the encoding of the data you are bringing into Excel. None of the Office apps support bringing in ANSI data and converting it to show Unicode characters.

Hindi is a Unicode based script/language and it seems that the data you are using is in ANSI or some other non-Unicode format.

So, the solution is to go back to where the data is being created and ensure it is being created in such a way so that the data is in Unicode. We have seen some cases where some locally produced keyboards are creating ANSI text instead of Unicode. There are also some fonts that are not Unicode, so the font being used can also impact this.

Thank you,

-Mike

Answer 3

Hi, 

Thanks for your reply. 

1. I am facing this problem in all files , I am feeding data in HINDI Language that is working perfectly, but when i try to 

    use filter, the language which i expect in the filter list is Hindi but it's not there ( I also attach the screenshot of the file )

2. No. I am not using Pivot table .