| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing Special characters in Excel | Excel Discussion (Misc queries) | |||
| Replacing special characters in Excel 2007 | Excel Worksheet Functions | |||
| Excel 'Special' Characters in Expressions | Excel Worksheet Functions | |||
| Excel 2003 - paste special option | Excel Worksheet Functions | |||
| Putting special characters into Excel... | Excel Discussion (Misc queries) | |||
Hybrid Mode
