- Excel Version
- 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.
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.
