LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 471
Default Illegal Character Imported

I am importing data from another system into an Excel File. In some cells I
get a character that in Excel looks like a question mark with a border around
it. If I copy that character and paste it in the VBA editor, it appears as
two Double Quotation marks "" with space between them and they are stacked
vertically. Anyway, my question is, how can I test of the existence of this
character in the cell. If I can detect it is in there I can create a
work-around for my data. Is there some kind of a VBA command that checks for
the existence of specific ascii characters (I don't know what ascii character
it is.) Below is a copy of it, pasted in he
"
"

Thanks for any help.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to delete a "return" character (a "box") in cell of imported d JaxHBT Excel Programming 1 August 12th 08 10:39 PM
Help removing "space" character from imported data smartgal Excel Discussion (Misc queries) 3 June 30th 08 07:38 PM
Remove character from imported data jimmxz Excel Discussion (Misc queries) 4 February 19th 07 06:13 PM
illegal division by 100 HUcube Excel Discussion (Misc queries) 2 April 3rd 06 09:02 AM
Illegal Operation Angela[_4_] Excel Programming 0 October 3rd 03 03:38 PM


All times are GMT +1. The time now is 10:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"