How to add characters in excel

Excel offers a very interesting way to add characters. We can cater to this problem statement by using the “‘” key in the keyboard. We can perform the below mentioned way to add characters in excel:

We’ll learn about this methodology step by step.

To do this yourself, please follow the steps described below;

Step 1 – Excel workbook

– Open the desired Excel workbook where you want to add a character/characters

Step 2 – Entering an apostrophe

– Now in any cell type in the “‘“ key. This will tell Excel that we want to add a character. Now if any formula/character/sentence is going to be typed in this cell, then excel will show it as characters only

Step 3 – Add characters of a formula after the apostrophe

– Now type in the characters of a sum formula i.e., “=SUM(5,6)“, and hit enter.

Step 4 – Text obtained

– We can see that the text is being displayed now as characters, even though we have typed a formula.