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

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.

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

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

"schackbo" wrote:

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.

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

"schackbo" wrote:

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.

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

You didn't like the response to your earlier post?

schackbo wrote:

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.

--

Dave Peterson