Viewing non-printable characters

R

refresh

Hi, I have an excel sheet containing downloaded data from a database. The
database reporting function is not working properly and I thought it may be
because the data contains non printable characters such as spaces or carriage
returns. I know how to view these in MS word but haven't found an equivalent
function in Excel.

I had thought of moving all data to Word to identify these but it doesn't
pick them up. Do you know if Excel has a function that will display these
characters on screen and could you tell me how to use please?

Thanks for your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show or Hide control characters in a cell (using Excel 2007)... 0
Is there an option to view Special (control) Characters in Excel 2 3
Checking characters , non-printable etc. 1
I need to cut characters off of a list of text cells... 2
Replace non printable characters 4
Substituting for special characters 4
How do I get more than 255 characters into a cell? 3
remove alpha or non-numeric characters from cell 8

Top