• If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
  • Excel articles and downloadable files provided in the articles have not been reviewed by MrExcel Publishing. Please apply the provided methods / codes and open the files at your own risk.
    If you have any questions regarding an article, please use the Article Discussion section.
DRSteele

Utilising the function UNICHAR

Excel Version
  1. 365
Sometimes we wish to find characters to place into our spreadsheets but are unsure where to look and how to find them. Function UNICHAR allows us to enter a number and it will report the character. Mike Girvin from ExcelIsFun recently created a youtube video that shows ways of listing them - as you can see, there can be over 143,000 of them! Looking through such a list is not practical.

There is one website that has done a terrific job classifying most of the available characters. I adapted it for use in Excel. It works similarly, but is specifically for Excel, which cannot show all the characters that an HTML page can. The file I created has been uploaded to OneDrive (at this link), which you can download. It contains a small amount of VBA code so that selection boxes and scroll bars function.

Let us know if there are improvements that can be made.
Author
DRSteele
Views
925
First release
Last update
Rating
0.00 star(s) 0 ratings

More Excel articles from DRSteele

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top