I have text with embedded non-printable characters through out a large
worksheet of data.

For example,
Collected $98 incash, $5checks4/25/02 Moved, left no addres

If I use CLEAN(), it works but leaves me without a space...I could use
substitute, but I don't know what ascii character this is?

Has someone written a little macro that goes through the text and
prints out each characters acsii code? I've tried doing it manually
with ASCII(text) but haven't been able to use that either. In
addition, these characters are embedded all over the spreadsheet and I
have no way of knowing if it is the same np character or multiple np
characters.