Adding a custom font and applying it to only a specific column

[amilpbi]

I have an excel sheet containing cell elements in Hindi language but its not in unicode,
its in this "dq- bZ'kuk txkrh" and when Abbasi 728 font is used, reveals its actual value in Hindi   "".

Unsure why this happens but unfortunately the data is in this format in the source itself and using python to encode - decode it did not work. 

Since this font seems to be the only thing that worked, Is there any way where we can add this font to the pre-existing fonts and then apply it to a single specific column? Or better extract the Hindi lettered names  

[rajendraongole1 · Accepted solution]

Hi @amilpbi - The text in your Excel file is encoded using a legacy font (Abbasi 728) rather than Unicode. Such legacy fonts use specific character mappings to render text.

If available, some tools or services provide font-to-Unicode conversion for legacy fonts like Abbasi 728. You can:

Search for "Abbasi 728 font to Unicode converter."
Copy-paste the text from Excel into the tool.
Export the converted Unicode text.

Download All Hindi Fonts | Abbasi Stylish Font | Abbasi Fonts

Be aware that converting legacy fonts to Unicode may not always be straightforward, especially if the font uses a proprietary encoding scheme. In such cases, manual adjustments or specialized tools may be necessary. Additionally, ensure that the converted text is accurate and retains its original meaning.