Microsoft does not guarantee the accuracy of this information. Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. (File> Word Options>Display>Check/Uncheck Show These Formatting Marks ) To see just some of these characters all the time, go into Word’s Preferences (Mac) or File > Options on a Windows computer. We may show/hide the non-printing character. To hide the symbols again, click the pilcrow icon once more. This function will remove any spaces, tabs.

The first way is to use the TRIM function.

In tables you will see one additional character, the universal monetary symbol (¤), which displays variously at various point sizes and magnifications but upon close inspection is seen to be a circle with four lines radiating from the corners There are a few ways to get rid of non-printing characters in Excel.

More accurately control the look of your document and what it contains. You can quickly tell, for instance, when you have inserted two spaces between words or added an extra carriage return. As far as I know, the non printing character is much easier to understand spacing when the characters are displayed.

What are non printing characters