|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
08-27-2008, 04:00 PM
|
|||
|
|||
|
Unprintable characters in Excel
I have an Excel workbook that has a range of data that was downloaded from another application. The range contains un-printable characters. The TRIM worksheet function didn't remove them. By using the CHAR worksheet function on each individual character of the contents of one cell, I determined that it was CHAR(160) that is the offending, un-printable character.
We copied and pasted this invisible character to the "Find and replace" feature of Excel. We replaced this invisible character with nothing (null) throughout the range. Is there an easier way to do this? 
|
|
#2
08-27-2008, 04:12 PM
|
||||
|
||||
|
__________________
_________________________________________   Credo Elvem ipsum etian vivere _________________________________________ A message for cross posters Please remember to wrap code. Forum Rules Please add to your signature if you found this link helpful. Excel links !!!
|
 |
| Bookmarks |
| Tags |
| unprintable characters |
New topics in Excel 2007 Help
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to set & lock an Excel field to a specific number of characters? | JonHook | Excel General | 2 | 12-10-2007 12:06 PM |
| Excel 2007: OpenDatabase fails to connect to a SQL database | jpc | Excel Programming | 0 | 11-23-2007 09:36 AM |
| SharePoint and Excel Macro Interactivity | maverick_abhi | Excel Programming | 0 | 10-22-2007 01:02 AM |
| processing a string by Excel | mark_neil2 | Excel Programming | 10 | 06-20-2007 08:35 AM |
| how to merge data from one excel into another excel | refreshplease3 | Excel Programming | 1 | 10-23-2006 09:51 PM |
Linear Mode
