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

  • Thread starter Thread starter schackbo
  • Start date Start date
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.
 
My apologies - I meant is there an option in Excel 2007, not Word. Sorry for
the confusion.
 
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...
 
Back
Top