If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|