I’ve always wanted to learn the art of typing any character from a certain set of fonts. For example, ¤. But, how do I do that, is the question? Now, take a quick look at your keyboard. Do you see ¤ characters? You are not, are you? Actually you didn’t look right, it’s there.
Open a word document. Hold down the Alt key and type 0164. Release the Alt key and you should see ¤. Similarly, there is a code for each character. We’ll show you how to find them all.
We will use MS Excel and its two built-in functions – row and char to find the code for all characters.
- function row: returns the row number of a reference
- char function: returns the character specified by the code from your computer’s character set
So when you write the formula =char(row()) and say, you are in row 1, the formula becomes =char(1) and then it returns the character represented by 1.
Cool Tip: Here’s how to easily get such characters in Mac. And if you intend to use them in email quickly, we’ll help you there too.
Steps to find characters
Step 1: Open an Excel workbook and enter the formula =char(row()) in row 1 of any column.
Step 2: Keep the bottom right edge of the cell by left clicking and coloring (drag) until row number 255.
Step 3: When you release, you will see all the characters from that font set. You can now copy-paste one column to another and then change the font style to see characters from another font set. Here is a section from 4 different font sets.
In this way, you can maintain your own repository of the font styles you use and the characters you care about. It’s simple and doesn’t require much effort.
Use font characters
When you want to type a character, find that character in your Excel sheet. Note the row number. Then enter the row number prefixed with zero (0) while holding down the Alt key.
For example, if your character is in row number 88, you should enter the code 088 by pressing the Alt key.
Over time, you will memorize some codes. At least you’ll remember the ones you use often. And, then you will be able to save a lot of time.
There is another way
Another way to practice and learn such codes is to use the Windows Character Map tool. Here’s how to do it.
Step 1: Open the run dialog (Windows + R), type charmap and press Enter. Refer to the image below.
Step 2: It will launch the Windows Character Map modal window. Navigate to what you need. You can Select And Copy it to the clipboard or check the key combination on the bottom right edge as highlighted below.
Conclusion
Combining a few Excel formulas can yield interesting and wonderful things. If you want to learn some more interesting information about characters and different types of codes, check out this article from the Microsoft support team.
Categories: How to
Source: thpttranhungdao.edu.vn/en/