Use the CHAR function to determine special characters - Text Functions - Microsoft Excel Tutorials

Use the CHAR function to determine special characters in Microsoft Excel

To use special characters, it is necessary to figure out how to get them. The CHAR function in Microsoft Excel will return the character specified by a number in column A. Note that some fonts may have different special characters.  

To determine special characters:

1. Copy Column A as shown below to your worksheet.
2. Select cells B2:B16 and type the following formula:=CHAR(A2).
3. Press <-Ctrl+Enter->.

Watch the Video Tutorial - https://www.youtube.com/watch?v=JbnSOkmf1eA