Is there an option to view Special (control) Characters in Excel 2

S

schackbo

I constantly import files into Excel 2007 (from CSV or Access files) and oten
there are carriage returns hiddin within the data. Is there an option in Word
2007 that I can turn on so I can see the special (control) characters? There
was an option in Word 2003 under Tools, and under the International Tab. I
can't seem to find any options that will display control characters. I don't
need to identify each control character - I'm just looking for a view that
will display the small boxes denoting control characters.
Any help would be appreciated.
 
S

schackbo

My apologies - I meant is there an option in Excel 2007, not Word. Sorry for
the confusion.
 
S

schackbo

schackbo said:
I constantly import files into Excel 2007 (from CSV or Access files) and oten
there are carriage returns hiddin within the data. Is there an option in Excel
2007 that I can turn on so I can see the special (control) characters? There
was an option in Word 2003 under Tools, and under the International Tab. I
can't seem to find any options that will display control characters. I don't
need to identify each control character - I'm just looking for a view that
will display the small boxes denoting control characters.
Any help would be appreciated.
Click to expand...
 

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

Display or hide control characters in Excel 2007 1
Viewing Control Characters 3
Show or Hide control characters in a cell (using Excel 2007)... 0
Substituting for special characters 4
Re: Formula to Remove Special Characters 5
Strange characters in Excel 2
Removing Special characters in Excel 8
Leading Zero dropping off after export to Excel 3

Top