If you inspect the result, the data is sorted by 'Unicode Name', which also automatically sorts the row data.Īdditionally, we can hide the 'Unicode Name' column according to our needs. Step 8: Click on the drop down besides 'Unicode Name' header and choose 'Sort A to Z'. You should see your table as shown below, with sortable headings and formatting. Step 7: Check 'My table has headers' and click on OK, since we have headers defined for the table. Step 6: Select the whole table and use 'Format as Table' and choose a format. Step 5: Drag and drop the formula from cell B2 upto B11, to see the result for all the rows. Step 4: Check the result of the conversion on cell B2 Step 3: Type the formula '=font2unicode(A2)' in cell B2. Step 2: Type the heading text as 'Unicode Name' or anything of your preference.

Step 1: Insert a new column after the name.

Follow the instructions below to perform sorting in Excel:Īssuming we have the following table that needs to be sorted according to name. Please download the latest version of Nepali Functions Addin for Excel v7 from the link below:Īfter you have installed the addin following the instructions in the above link. And with rigorous testing, I am finally happy to announce that the function is available in excel now. So, i tried my best to come up with the function. I got many request to implement the same in excel, but the problem was that there is no function available for the conversion from preeti/kantipur font to unicode. I had implemented the online version of it sometime back which is available here: So, the only solution this was to convert the text from preeti/kantipur font to unicode, and then sort it and convert it back. Since preeti/kantipur font uses a different scripting internally, sorting using normal excel function will result in sorting according to the english alphabet rather than the preeti/kantipur font text.

Preeti font to unicode