How To Remove Special Characters In Excel Trademark Registered Copyright

Maybe this has been annoying you forever. Or maybe you lot've noticed it only since you've upgraded your version of Excel. Or maybe you accept already have discovered the cause and solution for this piddling Excel annoyance. Don't get me wrong, AutoCorrect can exist a pretty useful feature in Excel only there ARE times when it tin can get in the way. 1 of the most common complaints I hear regarding AutoCorrect is its tendency to display a copyright symbol (i.east. � ) whenever a usually-used bullet bespeak (c) is typed.

Autocorrect Changes C In Parentheses To Copyright Symbol in Microsoft Excel 2007 2010 2013 2016 365

Same goes for Excel 'autocorrecting' (east) to a Euro symbol (i.e. � ) and 'autocorrecting' (r) to a registered trademark symbol (i.e. � ).

If you never utilize these symbols in your worksheets, y'all CAN make Excel stop.

Thankfully at that place is a simple solution.

ane) From the File tab click Options. The Excel Options dialog opens;

two) On the left side of the dialog box click Proofing and then click the AutoCorrect Options... push button;

3) On the AutoCorrect tab you will see a list of characters and symbols in the Replace / With section;

4) Scroll down and notice the (c) in the Replace column, select it and click the Delete button. While y'all're here, have a look at the other items in the AutoCorrect list such equally '(eastward)' and '(r)'. You tin delete whatsoever others that have been causing y'all grief too;

five) Click OK.

Prevent Autocorrect Copyright Symbol in Microsoft Excel 2007 2010 2013 2016 365

If you ever need to add either of these symbols back into AutoCorrect, type the value you desire to supervene upon in the Supplant cavalcade and, in the 'With' column, hold down the ALT key on your keyboard and type the following codes. Note that you have to type these numbers using the numeric keypad, not the numbers row on the meridian of your keyboard.

Replace	With	Agree downwardly the ALT cardinal and blazon (yous must use the numeric keypad)
(c)	�	0169
(r)	�	0174
(tm)	�	0153

Undo a Detail AutoCorrect Item

If you lot don't want to permanently delete an particular from the AutoCorrect listing only still want the text to display exactly as you type it, there is another uncomplicated solution.

As y'all are typing the text, such as (c), and Excel automatically changes it to � (i.e. a copyright symbol), immediately press CTRL+Z (i.e. Undo) and it will disengage the autocorrection and brandish exactly what yous typed.

Note that you must press CTRL+Z, immediately afterwards the autocorrection occurs , as you are typing . For example, the autocorrection occurs after y'all blazon a space or other graphic symbol following input of an AutoCorrect item.

Undo Ctrl Z Autocorrect Copyright Symbol in Microsoft Excel 2007 2010 2013 2016 365