Non-Printable Characters

[John Bates]

Hi,

Is there a way to display non-printable characters (e.g, carriage returns) in a worksheet? I know that I can clean them out using CLEAN(), but I also want to locate all cells that have them before cleaning.

Thanks,
John

[Palmetto]

You could use Conditional Formatting to highlight the cells by searching the text for the carriage return character.

=SEARCH(CHAR(10),A1,1)>0

[shg]

On my computer, non-printable characters show up as a box with a question mark. Not on yours, I gather?

[ChemistB]

You can try this formula

Please Login or Register  to view this content.

Is that what you're looking for?

[John Bates]

Awesome, works great!! Very creative solution!