Home MS Excel TutorialExcelTips and Tricks How To Deal With Special Characters In Formula In Excel

How To Deal With Special Characters In Formula In Excel

by Easy Excel Tutorials

How To Deal With Special Characters In Formula In Excel

The special characters in Excel can be understood in different ways. How to deal with it when using it depends on the person using it.

In this example, we have legal issues, our sales have been requested by an investor, and we want to inform the investor that the document is protected by a copyright.

Our data looks like this:

data




Click on the middle of the data (1), type in =char(169) & “Copyright Jennifer Corporation 2014”.

copyright special character

This is how to add copyright symbol to Excel formula. The same way you can add other symbols.

Template




You can download the Template here – Download

You may also like