How to Make a List of Special Characters in Excel (3 Easy Ways)

Whenever you are working with Excel, at some point you will need to use some special characters in your Excel sheet. The main objective of this article is to show you the list of special characters in Excel.


Download Practice Workbook


What Are Special Characters in Excel?

Special characters are those characters that do not fall under numeric or alphabetic characters. Special characters include symbols such as punctuation marks. Each special character is encoded with a code and internally saved using a predetermined ASCII code.

There are multiple uses of special characters.


3 Simple Ways to Make a List of Special Characters in Excel

Here, I will show you how you can create a list of special characters in Excel in 3 simple ways. I will be using the following dataset to make a list. The dataset contains the Character Code of all the special characters.

3 Simple Ways of Creating a List of Special Characters in Excel


1. Using CHAR Function to Create a List of Special Characters in Excel

In this first method, I will use the CHAR function to create a list of special characters in Excel.

Let’s see the steps.

Steps:

  • Firstly, select the cell where you want the symbol for your special character. Here, I selected cell C5.
  • Secondly, in cell C5 write the following formula
=CHAR(B5)

Using CHAR Function to Create a List of Special Characters in Excel

Here, the CHAR function takes the character code in cell B5 as input and returns the Character Symbol as output.

  • Finally, press ENTER and you will get your special character.

Using CHAR Function to Create a List of Special Characters in Excel

  • Now, drag the Fill Handle to copy the formula to all the other cells. 

Here, in the following picture, you can see that I have copied my formula.

Using CHAR Function to Create a List of Special Characters in Excel

I copied the formula to all the cells until I reached the last cell of my dataset.

Using CHAR Function to Create a List of Special Characters in Excel

Now, to give the list more meaning, I have written the Character’s Name also.

Here, In the following image, you can see the final list of my special characters.

Using CHAR Function to Create a List of Special Characters in Excel

Now, in the following picture, you can see the special characters list for character code 96 to character code 134.

Here, in the following picture, you can see the special characters list for character code 135 to character code 149.

Now, in the following picture, you can see the special characters list for character code 150 to character code 162.

Using CHAR Function to Create a List of Special Characters in Excel

Here, in the following picture, you can see the special characters list for character code 163 to character code 174.

In the following picture, you can see the special characters list for character code 175 to character code 186.

Finally, in the following picture, you can see the special characters list for character code 187 to character code 191.

Using CHAR Function to Create a List of Special Characters in Excel

Read More: Character Code for Check Mark in Excel (2 Applications)


2. Use of Keyboard Shortcuts to Create a List of Special Characters in Excel

In this method, I will show you how you can create a list of special characters in Excel using the keyboard shortcut.

Let’s see the steps.

Steps:

  • Firstly, select the cell where you want the symbol for your special character. Here, I selected cell C5.
  • Secondly, in that cell type ALT+58. Here, 58 is the character code for the special character.

  • Finally, press ENTER and you will get your special character.

Use of Keyboard Shortcuts to Create a List of Special Characters in Excel

Now, I have written the Character Name and Keyboard Shortcut to give this list more meaning.

Here, In the following image, you can see the final list of special characters for character code 58 to character code 95.

Use of Keyboard Shortcuts to Create a List of Special Characters in Excel

Now, in the following picture, you can see the list of special characters from character code 96 to character code 134.

Here, in the following picture, you can see the list of special characters for, character code 135 to character code 149.

Use of Keyboard Shortcuts to Create a List of Special Characters in Excel

In the following picture, you can see the list of special characters for character code 150 to character code 162.

Now, in the following picture, you can see the special characters list for character code 163 to character code 174.

Use of Keyboard Shortcuts to Create a List of Special Characters in Excel

Here, in the following picture, you can see the special characters list for character code 175 to character code 186.

Finally, in the following picture, you can see the special characters list for character code 187 to character code 191.

Use of Keyboard Shortcuts to Create a List of Special Characters in Excel

Read More: Apply Formula to Identify Special Characters in Excel (4 Methods)


Similar Readings


3. Using ROW & CHAR Functions to Create a List of Special Characters in Excel

In this method, I will explain how can you make a list of special characters when you don’t know the character codes for these characters. I will use the ROW function and the CHAR function for this method.

Let’s see the steps.

Steps:

  • Firstly, select the cell where you want to write the Character Code. here, I selected cell B5.
  • Secondly, in cell B5 write the following formula.
=ROW()

Here, the ROW function will return the row number of the selected cell.

  • Finally, press ENTER and you will get your character code.

  • Now, drag the Fill Handle to copy the formula.

Using ROW & CHAR Functions to Create a List of Special Characters in Excel

Here, in the following image, you can see that I have copied my formula.

I copied the formula till I reached row 191.

  • After that, select the cell where you want your special character. Here, I selected cell C5
  • Next, in cell C5 write the following formula.
=CHAR(B5)

Here, the CHAR function takes the value in cell B5 as input and returns the Character Symbol as output for that input Character Code.

  • Finally, press ENTER to get the Character Symbol.

Using ROW & CHAR Functions to Create a List of Special Characters in Excel

  • Now, drag the Fill Handle to copy the formula.

Here, in the following picture, you can see that I have copied the formula till I reached row 191.

Using ROW & CHAR Functions to Create a List of Special Characters in Excel

Now, you will see that you have got a list of all the characters. But you don’t need that you only need the list of special characters.

At this point, I will hide the rows that I don’t need.

  • Firstly, select the rows that you don’t need.
  • Secondly, Right-click on those rows.
  • Thirdly, select Hide.

Now, I have hidden the rows I don’t need and in the following picture, you can see the final list of special characters for character code 33 to character code 63.

Using ROW & CHAR Functions to Create a List of Special Characters in Excel

Here, In the following image, you can see the final list of special characters for character code 91 to character code 138.

Now, In the following image, you can see the final list of special characters for character code 139 to character code 162.

Using ROW & CHAR Functions to Create a List of Special Characters in Excel

Here, In the following image, you can see the final list of special characters for character code 164 to character code 183.

Finally, In the following image, you can see the final list of special characters for character code 184 to character code 191.

Using ROW & CHAR Functions to Create a List of Special Characters in Excel

Read More: How to Check If Cell Contains Special Character in Excel (2 Ways)


Inserting Special Characters in Excel Using Symbols Feature

In this section, I will show you how you can insert special characters into your Excel sheets using the Symbols feature.

Steps:

  • Firstly, select the cell where you want your special characters. Here, I selected cell C5.

  • Secondly, go to the Insert tab.
  • Thirdly, select Symbols.

Now, you will see a drop-down menu.

  • After that, select Symbol from the drop-down menu.

Inserting Special Characters in Excel Using Symbols Feature

Here, a dialog box will appear.

  • Firstly, select the Special Characters tab.
  • Secondly, select the Character you want. Here, I selected Copyright sign.
  • Thirdly, select Insert.

  • After that, select Close to close the dialog box.

Inserting Special Characters in Excel Using Symbols Feature

Now, you will see that the Character is inserted into your selected cell.

  • Finally, press ENTER.

Here, in the same way, I have inserted all the other Characters in my dataset.

Inserting Special Characters in Excel Using Symbols Feature


Practice Section

Here, I have provided a practice sheet for you to practice.


Conclusion

To conclude, in this article I have covered how you can make a list of special characters in Excel. Here, you will also get a list of special characters. I explained 3 different methods of making a list of special characters. I hope this article was helpful for you. Lastly, if you have any questions feel free to let me know in the comment section below.


Related Articles

Mashhura
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo