Excel Guides

Getting Rid of Non-Printing Characters Intelligently in Excel

There are a few ways to get rid of non-printing characters in Excel. The first way is to use the TRIM function. This function will remove any spaces, tabs, or other non-printing characters from a cell. To use the TRIM function, select the cell that contains the non-printing characters and then click on the Formulas tab. Next, click on the Text Functions drop-down menu and select TRIM. This will remove any non-printing characters from the selected cell.

Another way to get rid of non-printing characters in Excel is to use the CLEAN function. This function will also remove any spaces, tabs, or other non-printing characters from a cell. To use the CLEAN function, select the cell that contains the non-printing characters and then click on the Formulas tab. Next, click on the Text Functions drop-down menu and select CLEAN. This will remove any non-printing characters from the selected cell.

If you want to remove all non-printing characters from a worksheet, you can use the Find and Replace feature. To do this, click on the Home tab and then click on Find & Select in the Editing group. Next, click on Replace in the drop-down menu. In the Find what: field, type a space followed by a period ( . ). Leave the Replace with: field blank and then click on Replace All. This will replace all of the spaces with periods and will remove all of the non-printing characters from your worksheet.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.