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.
NEPALI UNICODE CONVERTER TO KANTIPUR DOWNLOAD
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.
0 kommentar(er)
